advanced filter with criteria list with numbers

L

lost_13

Can you help?

I have a criteria list with numbers in a column:

ID#
12
15
45
76

How can I make Excel stick exactly to these criteria, rather than filtering
also records with ID# 125, 151, 4577, 76032, etc.?

Thank you!
 
P

Peo Sjoblom

Works for me, maker sure you have real numbers. if you filter text values
with numbers they will
return that way but not real numbers. You can try to see if this helps

=12
=15
=45
=76




where each cell will look like

="=12"

and so on


--


Regards,


Peo Sjoblom
 
L

lost_13

Thank you, Peo. (-:
Worked for me in a new spreadsheet.
Will figure out what is wrong with my old one.
Probably some text format, as you suggested.
 
Top