Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
hi there...i am using advanced filtering (excel 2000) and am looking for a
way to further filter my data My Criteria currently reads: REGION MM-YY MM-YY =200212 =<200305 <=200312 Sample Filtered Data using above filter: REGION MM-YY ------------------------------ 1234 200212 123401 200212 12340101 200212 1234010101 200212 123402 200212 12340202 200213 1234020201 200213 I WANT TO ADD another criteria - under REGION i want to limit selections to only those region #'s which have UP TO 8-digits.. I don't need to see the entries with 10-digits (ie..1234010101, 1234020201)... the REGION COLUMN, by the way is formatted as "General" (long story - document imported from .txt and contains macros to reduce to this point) appreciate any assistance u can provide! Sandi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
extracting numbers from string | Excel Discussion (Misc queries) | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Sorting imported "numbers" | Excel Discussion (Misc queries) |