Feb 16 2021 02:27 AM
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?
Feb 16 2021 03:52 AM
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.
Feb 16 2021 12:13 PM
Most probably Power Query could help if you consider this option.
Feb 17 2021 01:01 AM
@Faraz Shaikh i have office 2010, I am attaching an example file where I need to copy the second number of the same name
Feb 27 2021 04:23 AM
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.
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.