gregfthompson
asked on
Excel - list the numbers that are extra in Column B but not listed in Column A
Column B contains 241 numbers that are not listed in Column A.
The request is to be able to find and list the 241 numbers separately in Column C.
Missing-numbers-problem.xlsx
The request is to be able to find and list the 241 numbers separately in Column C.
Missing-numbers-problem.xlsx
Hi,
pls try in C2
Regards
pls try in C2
=IF(ISERROR(MATCH(B2,A:A,0)),B2,"")
and fill-downRegards
@Rgonzo1971: That would over-write the existing data in Column C?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks.
Perfect.
Perfect.
You're right - I have no idea what I was looking at!
What is the significance of the numbers in Column C?
If 241 entries are put in C, what happens to the items already there?
Do they represent the answer that you want to get, but using formulae rather than typed in? If so, why are there only 10, when you mention that there should be 241?
Thanks,
Alan.