So it'll find which row the series named "A" has its first entry, the one you labeled A1, and then in column C it'll look up the X value, and in column D it'll look up the Y value. Now that you have sequential labels for all elements of all series you can do lookups.ī2=Match(B$1&$A2,Sheet1!$D$1:$D$100,FALSE)Ĭ2=IF(ISERROR(B2),"",INDEX(Sheet1!$B$1:$B$100,B2))ĭ2=IF(ISERROR(B2),"",INDEX(Sheet1!$C$1:$C$100,B2))Īnd just add 3 columns just like that for each of your series. This will give values such as B3 for the 3rd element of the B series. What I would recommend is transforming the data in a dynamic way that is easier to place a spot for each series by itself. Excel won't dynamically add new series, so I'm going to assume while the data can change, the names and number of series won't.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |