| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hello!
Thanks for feeding back.
Pete On Mar 12, 6:40*am, asorina wrote: "Pete_UK" wrote: 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 "asorina" wrote in message ... i want to select in a column, all number that are compose in 3 digits? Thank's, it's works! Have a nice day!- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
