| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
if-statement
you could put an extra column in your spreadsheet which tests the date and returns "ignore" or "use" then just put that criteria in the top left box in the pivot table layout and set it to "use" You will then only analyse the required data -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=528129 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reconcile two months statement? | Excel Discussion (Misc queries) | |||
| SET statement tutorial | Excel Discussion (Misc queries) | |||
| If statement | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
| IF Statement nightmare | Excel Discussion (Misc queries) | |||
Threaded Mode
