View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harold Good Harold Good is offline
external usenet poster
 
Posts: 81
Default 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