Creating Lists from imported data

[LukeFerry]

Hi

I have the following data which i need to be able to create a list (see attachment) What formula would I use?

Regards
Luke Ferry

[FlameRetired]

Luke,

If your project has room for a helper column it will be simpler.

Array enter this formula in C10 (already done in the attached) and fill down until you get blanks. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by pressing and holding Cmd while hitting Enter. (I am not familiar with Mac, but former posts say that's the way array formulas are entered on a Mac.) You will know the formula is properly committed when you see curly braces {} around the formula in the formula bar. You don't type those in yourself. Excel does it for you. If you do you will get errors.

Please Login or Register  to view this content.

That will return row numbers for each name in the source A3:T6.

Then in A10:B32 enter this non-array formula.

Please Login or Register  to view this content.

That will return the names.

[LukeFerry]

Hey Dave

Thanks for the assistance your solution works perfectly

Cheers
Luke Ferry

[FlameRetired]

Glad to hear it. Thanks for the feedback and the rep.