Can't afford to waste time so I hope you don't mind if I delve straight into the problem. My sister has somehow managed to mess up a spreadsheet she was working on for work.
There are 3 columns,
customersA ,, locationA ,, otherA
somehow her LOCATION is wrong for the corresponding CUSTOMER and if the location is wrong so is the data in the OTHER column.
she does luckily have a correct spreadsheet which we shall call b
customerB ,, locationB,, otherB
but there are some extra customers,,
therefore the issue is when I use a simple
=if (customerA = Customer B, location A = Location B, False)
the fact there are extra customers messes up the formula when I drag it down, as e.g.
CUSTOMER A
Alex
Bruce
Chris
dave
Edwards
CUSTOMER B
alex
amy
Bruce
Chris
dave
Edwards
so if I drag it down the extra customer Amy offsets the whole formula.
and just to add to the problems some of the customers have the same names and I can't change the duplicates to Amy1 amy2 as the customer list is 7000 customers long.
Please guys any suggestions are very much welcome!
My sister is in major help and stressed and i'm out of ideas.
We have been going through manually and has taken us 3 1/2 hours to do 690 of 7000 customers...
Bookmarks