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

--
Regards
Frank Kabel
Frankfurt, Germany

"Glennyboy" schrieb im
Newsbeitrag ...

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


--
Glennyboy
---------------------------------------------------------------------
---
Glennyboy's Profile:
http://www.excelforum.com/member.php...o&userid=16275
View this thread:
http://www.excelforum.com/showthread...hreadid=277135