create new list from list A, but with exclusions from a list B
Hi,
I'd like to create a new list from List A which might have up to 50 unique
numbers, but that may change as data changes. But there is a List B into
which a user can input some numbers from List A that he doesn't want to
appear in New List.
In the example below, New List is my goal. What formula can I use in New
List cells to calculate these numbers in New List?
Sorry these columns probably won't line up.
List A List B New List
272 992 272
68 111 68
111 14 260
260 299
299 233
233 261
14
261
992
|