Forum Discussion
Frank145
Mar 25, 2024Brass Contributor
Counting unique devices based upon a "Wave" column
Hi, I am trying to get a count of all UNIQUE devices in a list that are planned to move in a specific wave. Attached is the example workbook I am working with. In the "MasterServerToApp" tab I am ...
ConnorAlign
Mar 25, 2024Copper Contributor
Hi Detlef,
I am working with Frank145 and after plugging in the formula, I see that it is only counting the unique devices in the "Server" column. While the original ask was to Count unique devices that were in a specified wave column.
Essentially, Only counting the unique devices based on a cell value/criteria.. In this case we have a "Wave" column to distiguish the different waves these servers may move during.
Let us know if further info is needed.
Thanks!
I am working with Frank145 and after plugging in the formula, I see that it is only counting the unique devices in the "Server" column. While the original ask was to Count unique devices that were in a specified wave column.
Essentially, Only counting the unique devices based on a cell value/criteria.. In this case we have a "Wave" column to distiguish the different waves these servers may move during.
Let us know if further info is needed.
Thanks!
Frank145
Mar 25, 2024Brass Contributor
thank you Detlef_Lewin, and ConnorAlign