Since I could find much of a straight answer in my googling, I am turning in here for an expert help.
I have an excel file with almost 15 sheets in it, and each sheet has more than 17 columns filled with different number combinations which goes down in various row length. I am in need of help to retain only the values in cells which are unique. I need all repetitions to be deleted across columns, rows and sheets. So in effect a number like 509 should be there only one time across the whole file
Can you pls help me with your expertise.
Thanks in advance.
I have an excel file with almost 15 sheets in it, and each sheet has more than 17 columns filled with different number combinations which goes down in various row length. I am in need of help to retain only the values in cells which are unique. I need all repetitions to be deleted across columns, rows and sheets. So in effect a number like 509 should be there only one time across the whole file
Can you pls help me with your expertise.
Thanks in advance.
