advanced filter with criteria list with numbers

[Guest]

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!

 

[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

 

[Guest]

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.