Help Pleasssssse

G

Glennyboy

If I have a columb with names and a columb with ages which function do
use to produce a list of names with a certain age. I dont want to us
filters :confused
 
F

Frank Kabel

Hi
why don't you want to use a filter? All other solution would require
more or less complex (and slow) array formulas?
 
D

Domenic

Assuming that Column A contains the name, Column B contains the age, and
that your data starts on the second row...

Enter the following array formula using CONTROL+SHIFT+ENTER in D2 and
copy down:

=IF(ROW()-ROW($D$2)+1<=COUNTIF($B$2:$B$10,$C$2),INDEX(A:A,SMALL(IF($B$2:$B$10=$C$2,ROW($B$2:$B$10)),ROW()-ROW($D$2)+1)),"")

...where C2 contains the age of interest.

Hope this helps!
 
Top