... but let me explain!
I have a Worksheet with over a 1000 rows ...
In column n there is a value "Active" or "Inactive" for each row ...
I want to identify rows with a value "Active", easy if IDs have only 1 row but ...
Some, but not all, IDs have 2 rows ...
Where I want to identify IDs with a value "Active" on both rows, but not those that have "Active" on one row, but "Inactive" on the other row ...
Any ideas?
Thanks ...
I have a Worksheet with over a 1000 rows ...
In column n there is a value "Active" or "Inactive" for each row ...
I want to identify rows with a value "Active", easy if IDs have only 1 row but ...
Some, but not all, IDs have 2 rows ...
Where I want to identify IDs with a value "Active" on both rows, but not those that have "Active" on one row, but "Inactive" on the other row ...
Any ideas?
Thanks ...