Problem with double and unique values

Copper 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?

4 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

 

Hi @dipadiego,

 

Please the below construction of your formula should read as below in column B

 

=IF(COUNTIF($C$2:C2,$C2)=2,A2,"")

 

This will pull the value from column "A" when the count is 2, then you can just filter the value and copy them to another sheet. Also I have added conditional formatting which will highlight the second value in the dataset. Make sure you select the range correctly to get the results.

 

2021-02-27_15-18-05.png

 

Attach is the sample file.

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.