Problem with double and unique values

%3CLINGO-SUB%20id%3D%22lingo-sub-2138769%22%20slang%3D%22en-US%22%3EProblem%20with%20double%20and%20unique%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2138769%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20have%20in%20the%20lines%20two%20different%20telephone%20numbers%20for%20the%20social%20reasons%20of%20the%20same%20customers.%20how%20can%20i%20delete%20duplicate%20company%20names%20by%20copying%20the%20second%20phone%20number%20in%20the%20next%20column%3F%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2138769%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I have in the lines two different telephone numbers for the social reasons of the same customers. how can i delete duplicate company names by copying the second phone number in the next column?

3 Replies

Hi @dipadiego 

 

Could you please let us know you Excel Version? is it Microsoft 365 (formally Office365)

 

Also, please share few sample records with your desired output enter manually.

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.

@dipadiego 

Most probably Power Query could help if you consider this option.

@Faraz Shaikh i have office 2010, I am attaching an example file where I need to copy the second number of the same name