Sai Prabhu
New Member
Doc ID – There can be unique and duplicate IDs in DOC ID Column
Value – There can be Positive and Negative Value in the Value Column
Criteria : If there are duplicate Doc IDs and Value Column contains both Positive and Negative values (Numbers will be same), then can you please provide formula to highlight/indicate all the rows to be deleted.
Sample Data:
Doc ID Value Outcome
12345 -10 Delete Row
56789 5 Do Not Delete
52789 2 Do Not Delete
12478 -3 Do Not Delete
12345 10 Delete Row
12345 10 Delete Row
12345 5 Do Not Delete
Value – There can be Positive and Negative Value in the Value Column
Criteria : If there are duplicate Doc IDs and Value Column contains both Positive and Negative values (Numbers will be same), then can you please provide formula to highlight/indicate all the rows to be deleted.
Sample Data:
Doc ID Value Outcome
12345 -10 Delete Row
56789 5 Do Not Delete
52789 2 Do Not Delete
12478 -3 Do Not Delete
12345 10 Delete Row
12345 10 Delete Row
12345 5 Do Not Delete