28 Mar 2009

Excel - Search Criteria

This might seem very basic but i always find it best to document things all in one place.
Excel has a ways to search for data using operators
= Equal to
<> Not equal to
>= Greater than or Equal than
> Greater than
<= Less than or Equal than
< Less than
Wildcards in Excel use 2 different characters
* this is a wild card for any number of characters
An example of this could be 
Phi*
this could match phil, philip, philippe [Assuming these were in my worksheet]
? this is a wilcard for a single character.
an example of this would be
phi? would display phil
phi??? would display philip but not phil

No comments:

Post a Comment