returning a list of values meeting a specific criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of data in a worksheet #1 that looks like this after i run some queries

A B
1 Jim
2 Joe
3 Mary
4 Su
5 Frank

In worksheet #2, i want to be able to enter a criteria in a cell (like "X) and have it return all the names that have an X next to them in worksheet #1. something like this

A B
1 X Ji
2 Mar

4 Y Jo
5 Fran

Thanks in advance
 
Hi
you may try downloadind Alan Beban's array functions
(http://home.pacbell.net/beban)
They'll include a function called VLOOKUPS (for returning multiple
lookup results)

--
Regards
Frank Kabel
Frankfurt, Germany

greg said:
I have a list of data in a worksheet #1 that looks like this after i run some queries:

A B
1 Jim X
2 Joe Y
3 Mary X
4 Sue
5 Frank Y

In worksheet #2, i want to be able to enter a criteria in a cell
Click to expand...
(like "X) and have it return all the names that have an X next to them
in worksheet #1. something like this:
 
Back
Top