Search criteria please

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

Guest

Hello from Steved

In Col D:D I have 4 numerals, sometimes by mistake somebody has type in a 5
numeral figure please what would the search criteria be to find the 5
numerals only.

Thankyou.
 
Hello from Steved

In Col D:D I have 4 numerals, sometimes by mistake somebody has type in a 5
numeral figure please what would the search criteria be to find the 5
numerals only.

Thankyou.
Click to expand...

Steve
Select Column D, click Data, Filter, Auto Filter
Then click the drop down box and click custom
In the left drop down box click is greater than, in right colum write
9999 and press enter
Click to expand...
Records having more than 4 digits will be shown on screen
when finished, click Data, Filter, Auto Filter again

Aqib Rizvi
 
Select your range
Edit|Find
What: ????? (match entire cell contents)

Find Next (or Find All)
 
Back
Top