Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Filtering by digits
I have a dataset of about 5000 rows, in it there are product codes of varying length, i just want to filter the 4-digit numbers. Unfortunately the numbers are in text format because some begin with zero's. Anyone got any ideas? Chris -- cj21 ------------------------------------------------------------------------ cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673 View this thread: http://www.excelforum.com/showthread...hreadid=391277 |
#2
|
|||
|
|||
Use the formula =LEN(Cell Ref) where Cell Ref is the cell reference of the product code, this will return a value equal to the number of characters in the product code, then do a filter for the 4 -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=391277 |
#3
|
|||
|
|||
I'd use a column of helper cells:
=--A2 and drag down. Then filter by that column. Custom|is greater than 999. The -- converts the text numbers to number numbers. cj21 wrote: I have a dataset of about 5000 rows, in it there are product codes of varying length, i just want to filter the 4-digit numbers. Unfortunately the numbers are in text format because some begin with zero's. Anyone got any ideas? Chris -- cj21 ------------------------------------------------------------------------ cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673 View this thread: http://www.excelforum.com/showthread...hreadid=391277 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mod 10 & 11 | Excel Worksheet Functions | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
Help - Any number longer than 12 digits turns to scientific and ro | Excel Discussion (Misc queries) | |||
Concatenate function - keeping "displayed" extra digits | Excel Discussion (Misc queries) | |||
Least number of digits in Y-axis labels | Charts and Charting in Excel |