G
Guest
I have a spreadsheet that contains 1 column that contains cells that may
contain the same information such as A2 and A4 and A6 all contain 4144638872
- in columns B-P there may be information that may be different for each 1234
cell:
A2=4144638872 B2=278954
A4=4144638872 B4=195871
A6=4144638872 B6=238521
I want to return a result of unique rows based on only 1 phone # that exists
in column A. I need the information in column B and other columns and I
don't care which of the 3 remain in the result sheet. Basically I have a
list of file#s with the same phone #s and I only want to see unique phone #s
but I need the other informaiton in the other colums regardless of which one
gets picked as the unique identifier.
Any help will be appreciated.
Thank you,
contain the same information such as A2 and A4 and A6 all contain 4144638872
- in columns B-P there may be information that may be different for each 1234
cell:
A2=4144638872 B2=278954
A4=4144638872 B4=195871
A6=4144638872 B6=238521
I want to return a result of unique rows based on only 1 phone # that exists
in column A. I need the information in column B and other columns and I
don't care which of the 3 remain in the result sheet. Basically I have a
list of file#s with the same phone #s and I only want to see unique phone #s
but I need the other informaiton in the other colums regardless of which one
gets picked as the unique identifier.
Any help will be appreciated.
Thank you,