I have 2 different lists in excel.
The first one has all the business info, name, address, phone number, etc...
The next has the business phone number and rank in Google.
I combine both lists into 1 sheet and then add a function =IF(Phone Number is Equal to Phone Number above then Yes, if not No)
Is there a way to combine both rows when the answer to the IF function is Yes?
I have attached an excel file I have been trying to figure this out with.
Bookmarks