Daily reporting

[emoes]

Hello all,
I hope that I can get some help with something I can’t get done 
Attached you will find a excel sheet that is daily growing with an extract of scanning my network.
This shows on devices the status of installed software (and the version)
I would like to report in a pivot the amount of systems in the region, The amount scanned on day 1 and how many are compliant And also for day 2, day 3 etc..
This will lead to a pivot that shows the progress of updating the clients on the network.

This can be presented in a nice chart.
I would like to have the unique values on the scanned date, but the formula for unique values only shows the unique values on the total list and doesn’t stop ate the scanned date.
(but sometimes during scanning a extra client comes in, so the items will go up, but the Unique is stopping at the first found unique value and I would like to restart again when the last column contains a new date


AlexBekijk bijlage Helpmij.xlsx

 

[ExcelAmateur]

Je mag op dit forum gewoon in het Nederlands schrijven.

 

[VenA]

напрыклад

=n(countifs($a$2:a2;a2;$p$2:p2;p2)*countifs($a$2:a2;a2;$p$2:p2;p2)=1)

 

[emoes]

Bedankt voor de reactie.
Hier kan ik verder mee.

Alex