Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PivotTable: formula for added & removed
Everymonth I get a list of office codes, and I need to compare if there are
any changes (additions or deletions). Here is how the raw data comes in: Group Office Main Office Codes Date XBA MOFC 104 104 Aug-09 XBA MOFC 104 133 Mar-10 Then I create a pivottable where Group & Office are a page then Main & Office Codes are rows with Date and a column and the Count of Office Codes is the data. This way the months are side by side and I can visually see if there is a new code or old code removed. I want to go one step future and instead of doing it visually have a formula (or two) that tells me if a code has been added or removed. Thanks, Krystal -- Krystal K. Peters |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autoshapes loose formating when formula is removed | Excel Programming | |||
A Fix - Pivottable - Added calculated fields and now can't clear pivot | Excel Programming | |||
Pivottable - Added calculated fields and now can't clear pivot | Excel Programming | |||
pivot chart colors- how to keep from changing when data elements are added/removed? | Charts and Charting in Excel | |||
format a cell if the formula is removed | Excel Worksheet Functions |