Anyone? I tried to do very rudimentary things like filtering the list
for two conditions, like "contains stuff in row A" and/or "contains
stuff in row B", but using OR shows all rows with one condition, and
using AND shows nothing since no row matches both conditions. The OR
option does at least work, but it is not very elegant having to sort
through all the other trash, all the rows that all match the first
condition.

As an example, something like :

NAME=Fred
Age=14
END
NAME=Barney
Age=24
END

I just want to do things like find the names of all the people who are
24. FIltering the list for 24 shows just the line, so if I add a
condition OR "contains NAME", it works, but you have to visually scan
for rows with the age in them amongst the whole set of names. There
has to be a better way that I'm just not seeing. Thanks.


--
Spalding
------------------------------------------------------------------------
Spalding's Profile: http://www.excelforum.com/member.php...fo&userid=8634
View this thread: http://www.excelforum.com/showthread...hreadid=545608