I'm going to creating a whole series of spreadsheets where I need to start with an arbitrarily long set of data. The next tab of each of these sheets will need to pull data from that set, but also be able to insert a couple of rows between every 10 or so rows from the first sheet.
Because each spreadsheet will be slightly different in what needs to be inserted, and how often, I really just need to have a simpler way of doing things than I am currently. I've attached a sample set, with what I'm currently doing (that is, overly complicated formulas that do what I need, but very inelegantly, and are difficult to make changes to for subsequent worksheets). Maybe point me in the direction of really learning and understanding how to you INDEX and MATCH? Is there a good tutorial somewhere?
I'm currently using a COUNT function to determine when to insert rows, but I'm told that the datasets wil lsoon be changing from numerics to textstrings, so that's going to throw me for a loop.
Kind of a vague way of stating things, I know, but hopefully the attachment will clear things up.
Bookmarks