Forum Discussion

Frank145's avatar
Frank145
Brass Contributor
Mar 25, 2024

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 looking to count all UNIQUE devices (C or D column) that are moving in a specified wave (column L).

Using the example in the provided workbook, I want a unique count of all devices moving in wave 1. Since the servers repeat due to them supporting multiple applications, I do not want to count these devices mulitple times, instead only count it once.

The "# Number of Device" in the "Migration Schedule" should read "2" if functioning correctly.

The overall idea is to automate this process by feeding all data and counts from "MasterServerToApp" into the "MasterMigrationSchedule" tab.

Thank you, and please let me know if further clarification is required.

Kindly,

excel
Formulas and Functions

5 Replies

Sort By
    • ConnorAlign's avatar
      ConnorAlign
      Copper Contributor
      Mar 25, 2024
      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!

Resources