I need to count color based on input name column , if i give input name is YYY i want to get count color in that row
If i give input name YYY
Result i want below
Please anyone help me for this.
If you know the index of the column till where the row extends,then
- loop through the count
- Use Get Cell Color to get the color of each cell in that row
- Use a dictionary and add logic to chk if the colour exists in the entity if not then add to the dictionary as key and similarly assign 1 if not present else increment the counter in the value part of the dictionary
-The dictionary will contain the color and count
Thanks and Regards,
@Raja.G please try out this sequence
Sequence.xaml (24.2 KB)
set name here
result (result is a dictionary of the colors + # occurences)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.