Hello,
I have a query regarding find the unique count of yellow highlighted columns.
See below screenshot.
Output required- 2
There are 2 people in this range and format should like this only.
Hello,
I have a query regarding find the unique count of yellow highlighted columns.
See below screenshot.
Output required- 2
There are 2 people in this range and format should like this only.
For this, I’d use a Read Range activity for the yellow cells. Then, initiate a new empty list variable. Loop through the columns of the retrieved names. If the (at the start empty) list does not contain the name from the columns (see dt.Rows.Contains), add it to the list. Once all the columns have been looped through, you can use the list.Count property to see how many unique names are in the newly created list.
I’m sure there’s a clever way of doing this in LINQ too, but this should to the trick.
Thanks bro, I will try it
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.