Array Formulas instead of helper columns

**daddylonglegs** · 11-21-2009, 01:13 PM

No VBA.....sounds good to me

Try this for COL_B

=IF(ISNUMBER(MATCH(ROW(A2:A24),SMALL(IF(A2:A24<>"",ROW(A2:A24)),ROW(INDIRECT("1:"& CEILING(COUNT(A2:A24)/2,2)))*2-1),0)),A2:A24,"")

Array entered

for COL_C just remove the highlighted -1

**DonkeyOte** · 11-21-2009, 01:18 PM

dll, OP wants to generate the series' via Names - ie no cells in use other than those in A. The B&C values have already been generated via formulae (in earlier thread), question has now been revised hence my request for (this) new thread.

EDIT: would appear again I've misinterpreted requirements... note to self, don't try and answer ElmerS' questions as we're invariably on different wavelengths!