|
Not logged in [Login - Register] |
You Are Not Registered Or Not Logged In |
Corsa Sport » Message Board » Off Day » Geek Day » Excel help » Post Reply
|
12vStig |
posted on 26th Jun 15 at 09:32 |
Thank you! | |
Brett |
posted on 24th Jun 15 at 23:08 |
A thank you would suffice | |
12vStig |
posted on 24th Jun 15 at 22:20 |
Will give it a whirl, if it works will you accept Czechs? | |
Brett |
posted on 22nd Jun 15 at 20:59 |
You can't concatenate an array without adding another function so one way or another you'll be using VB editor. quote: then in column C on Sheet2 paste the following... quote: The above assumes you've followed your instructions as stated above. Sheet2 columns A/B will have start and finish row reference and column B on Sheet1 will have the names. If you'd like to change it from a space inbetween the name to something else like a comma then edit the " " bit in the function code. Pay me. [Edited on 22-06-2015 by Brett] | |
Gaz |
posted on 22nd Jun 15 at 20:35 |
Infact no, INDEX MATCH won't reference the cell's in-between your numbers. | |
Gaz |
posted on 22nd Jun 15 at 20:32 |
I'm sure you could manipulate a Index Match formula to do this but I think (without actually having a go) the data will need to be transposed with headers | |
VegasPhil |
posted on 20th Jun 15 at 12:51 |
I'd have thought that filtering would work better for what you are trying to describe and using names? | |
12vStig |
posted on 19th Jun 15 at 22:51 |
Need a formula that I'm not even sure exists, best way I can explain it is some sort of range lookup concatenate |