palaeontology
Active Member
- Joined
- May 12, 2017
- Messages
- 444
- Office Version
- 2016
- Platform
- Windows
This isn't a request to make one 'uniques' list combining all contents from two lists ... it's slightly different.
I have the following 2 Lists ... called List A and List B ...
I need a formula to remove from List B (to make a new List called 'Revised List B') any numbers that are also found in List A ... so the '2' and the '7' would be removed to leave just '1' and '4'
I don't want List A adjusted in any way, and I'm not looking to merge the two lists into one 'Uniques' list.
I'm not looking for a way to do it using the filter button within the Excel ribbon ... I need the solution to this to be a formula .(not VBA) .... if at all possible.
Any help on this would be much appreciated.
Kind regards,
Chris
I have the following 2 Lists ... called List A and List B ...
I need a formula to remove from List B (to make a new List called 'Revised List B') any numbers that are also found in List A ... so the '2' and the '7' would be removed to leave just '1' and '4'
I don't want List A adjusted in any way, and I'm not looking to merge the two lists into one 'Uniques' list.
I'm not looking for a way to do it using the filter button within the Excel ribbon ... I need the solution to this to be a formula .(not VBA) .... if at all possible.
Any help on this would be much appreciated.
Kind regards,
Chris