A
asorina
i want to select in a column, all number that are compose in 3 digits?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Pete_UK
In a helper column you can have a formula like this:
=IF(LEN(A1)=3,"Yes","No")
or like this if your numbers are proper numbers:
=IF(AND(A1>=100,A1<1000),"Yes","No")
Copy the formula down the helper column, then apply autofilter to that
column, selecting Yes from the filter pull-down.
Hope this helps.
Pete
=IF(LEN(A1)=3,"Yes","No")
or like this if your numbers are proper numbers:
=IF(AND(A1>=100,A1<1000),"Yes","No")
Copy the formula down the helper column, then apply autofilter to that
column, selecting Yes from the filter pull-down.
Hope this helps.
Pete
A
asorina
it's works!Pete_UK said:In a helper column you can have a formula like this:
=IF(LEN(A1)=3,"Yes","No")
or like this if your numbers are proper numbers:
=IF(AND(A1>=100,A1<1000),"Yes","No")
Copy the formula down the helper column, then apply autofilter to that
column, selecting Yes from the filter pull-down.
Hope this helps.
Pete
Thank's,
Have a nice day!
P
Pete_UK
Thanks for feeding back.
Pete
Pete
it's works!
Have a nice day!- Hide quoted text -
- Show quoted text -