Hello everyone
I hope someone can help.
I have Column A that has street names. In Column E is a figure of how many times the street name has been asked. In column F, i put a X when I know them.
Some times I add new data that includes duplicates in A where they have been asked again and the number in E increase. I know how to remove the duplicates and then I am left with the row with the higher value.
I want to transfer the X from Column F into the duplicate when it matches so i don't have to go through the whole sheet to put an X in again.
Can that be done?
Do I make any sense?
Many many thanks
Bookmarks