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.
|
Thats what I was getting at but haven't made one in ages... and yeah, not lookuptable, pivottable.