Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filtering
Hi
one way: - use a helper column - enter the following formula (assumption: col. A stores your part-number) =IF(AND(LEFT(A1,1)="R",ISNUMBER(--MID(A1,2,1))),"X","") and filter all entries with an 'X' in this helper column -----Original Message----- I have part numbers that start with RV RW RR... However, I only want parts that have an R and followed by a number.. R123456 R444444 I don't want any part that has a letter after the R... Thanks, DJ . |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filtering
Thanks Chris
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filtering (all) by value | Excel Discussion (Misc queries) | |||
filtering | Excel Discussion (Misc queries) | |||
Filtering | Excel Discussion (Misc queries) | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
Filtering | Excel Worksheet Functions |