|
|
#2
10-26-2014, 09:28 PM
|
||||
|
||||
If you call L1 'Row Suffixes' and use the following formula in L2 and copy down, you can then filter on that column:
=RIGHT(A2,6-FIND("-",RIGHT(A2,6)))
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Copy Multiple Rows to new workbook when multiple criteria is met.
|
flds | Excel Programming | 5 | 09-30-2014 09:58 AM |
| VBA Pivot Table CubeField Enable multiple items | Wries | Excel Programming | 0 | 03-13-2014 09:56 AM |
| Pivot table auto print. For multiple values. | Nicholaspoe | Excel | 0 | 10-08-2013 09:08 PM |
| Ranking with multiple criteria | angie.chang | Excel | 0 | 08-14-2012 04:49 PM |
|
Multiple criteria in SUMIF?
|
pumpkin head | Excel | 1 | 02-17-2006 09:06 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode