Hey - I need excel help. I have been given a really long messy worksheet. I need to pull single values that are all in the same column... but they're exactly 53 rows apart (and there are over 200 of them). In other words, the first value I need is in cell B3, the next is in B54, the next in B105, then B156, and so on... down to B11491. Is there a formula that will do that such that I end up with a discrete list of the values? Thanks!
=B2&""&B54""&B105""B156.. and so on you can put spaces between the quotes if you need spaces between your values
I just wanted to say that you have some sweet guitars, kpsta. I love the non-reverse P-90 Firebird and the 12 string Guild hollowbody. And I'm glad you figured out the Excel problem. :grin:
Sounds like you got it, but a sweet way to handle this is the INDIRECT function. Essentially, =INDIRECT(B3) will display the results of the cell B3. For your sheet you could have set up a column of formulas in column A. Since your values were 51 rows apart starting on row 3, you could use the following formula to determine the range. (((ROW(B3)-3)*51)+1) That would return 3 as your first value on row 3, then 54 on row 4, then 105 on row 5, etc. So on A3 you could enter =INDIRECT("B"&TEXT((((ROW(B3)-3)*51)+1), "####")) then copy that down to get your data in a nice neat column with no breaks. However, your problem sounds like creative sorting would be the easier approach.
