I have about 5000 rows (a1:g5000) of information, but some of the rows have duplicate information. How do I set up my document so that all duplicate entries in the B column remove the entire corresponding row?
(ie. if B501, b502 and b503 were the same value as b500, it deletes (a501:g503)
Thanks..
(ie. if B501, b502 and b503 were the same value as b500, it deletes (a501:g503)
Thanks..