Show progress on update process

emoes

New Member
Joined
Feb 18, 2016
Messages
6
Hello all,
I hope that I can get some help with something I can’t get done J
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
Alex
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top