|I have a sheet 1 as a master sheet now in there i need how many account numbers match so if 3 matchs it would say three.|
now in sheet 5 is where the data come in and the sheet 6 is the pre callers name.
now the pre caller would give a the account number in.
on sheet 5 is where the customer would rate the tech but it shows the account number
so i need excel to look at sheet 5 and 6 is match the numbers and then say 3 matches on to the master sheets.
Now i work at home with 2010 and i can get this to work with match. in work i use 2003 and i can not get it to match or if it does it will come back as say 73 matched and this is the problem as it looking at all the numbers and saying i.e 13 6 founds etc. can any one help please.