![]() |
|
#1
|
||||
|
||||
![]() 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] |
#2
|
|||
|
|||
![]()
Hi Macropod,
Thank you for your response. Yes, you are correct. However, is multiple label or value filter (all in one shot) possible using a pivot? From my findings using the pivot interface it is not. I was thinking maybe the pivottable object might allow for it via programming. Best Regards, Philip Last edited by philipq; 10-26-2014 at 11:02 PM. Reason: missed a statement |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
pumpkin head | Excel | 1 | 02-17-2006 09:06 AM |