Hi All,
Could you kindly help me how to validate below data set in excel ?
<tbody>
</tbody>
I would like to write a macro to validate that every group should only have one distinct ID
In the above example Group 2 are assigned with two ID's 113 & 115 that should be highlighted using the macro.
Thanks,
Rameez Shaik
Could you kindly help me how to validate below data set in excel ?
ID | Group_Name |
112 | Group 1 |
113 | Group 2 |
114 | Group 3 |
115 | Group 2 |
<tbody>
</tbody>
I would like to write a macro to validate that every group should only have one distinct ID
In the above example Group 2 are assigned with two ID's 113 & 115 that should be highlighted using the macro.
Thanks,
Rameez Shaik