Amanda Walshaw
asked on
missing transactions in excel
I have done a vlookup using the following formula
=iserror(lookup(A2,$B$2:$B 2:B$1885,0 ))
there is more data in column a, than there is column B I am trying to find the missing data not in column b.
see attached file
excel-issue.xlsx
=iserror(lookup(A2,$B$2:$B
there is more data in column a, than there is column B I am trying to find the missing data not in column b.
see attached file
excel-issue.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks for closing the question so promptly.
Good luck with the rest of your project.
Good luck with the rest of your project.
ASKER