I have 5 columns of data in excel. I want to get only the unique values?

Question

I have 5 columns of data in excel. I want to get only the unique values. First column has account number, second has names, third have phone numbers and fourth is having pin code. The account number column have duplicates, now I want to extract the account number, name, phone number and pin codes with duplication. how Can i Do it in excel.

Answer 1

insert additional column as the first column and input serial numbers.

next sort according to account number.

this will result in unsorted table by other columns.

now you can edit as you desire.

do this exercise in a copy and keep original file untouched.

did this help?

Answer 2

for the removal of duplication & extraction of unique values of the account number column select the any cell of the account number column then go to the "DATA" menu & click on the "REMOVE DUPLICATES" then mark the check box with the account no. column title & disselect the other check box & press the "OK" button then u will get the unique values .......

Answer 3

Yea it occurs to me to boot each and every from time to time, and without improve filtering gains, it fairly is going to take me perpetually to de-duplicate manually. (in spite of improve filtering) I take place to discover a information superhighway-app it fairly is talked approximately as podbox. It acts as a third social gathering application. between the coolest points is to de-duplicate products (different cleansing gains are additionally attainable) on excel certainly. it continues to be in alpha version although, and the provider is unfastened. cheers