0
votes
1answer
590 views

Single source worksheet, and multiple pivot tables using filtered data

How does one manage to create a workbook, where one worksheet is the master source data, but multiple pivot tables need to be created with the same set of "row labels" and "summed values", but ...
-1
votes
1answer
372 views

Highlighting duplicate column-pair and counting the rows Excel

Given the data below, the column-pair with the same values for at least 4 consecutive rows should be highlighted. Here's an image for better visualization: 2 2 3 4 3 4 3 4 3 4 2 3 1 2 ...