Quote:
Originally Posted by fotze
Pivottable will do that in seconds.
Highlight the data, including the Column Names
insert pivottable,
use that selection,
Click OK.
Drag the PO Field to the ROW LABELS Box
Drag the OpenClosed Field to the Column labels box
Drag the OpenClosed Field to the Values box.
Done.
|
This doesn't remove the duplication, unless I am doing something wrong.
If I have 2 opens under the same PO number, it puts a 2 in the pivottable, not a 1. I need to eliminate any doubles.
I need to report on how many assignments are open, which I can do using countif(), and how many POs have open assignments. In the past I have just counted the lines on the spreadsheet but that is a big PITA.