| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Eliminate Blank Rown in a List - Then Create New List | Excel Discussion (Misc queries) | |||
| I do not have the List-create a list option on my data toolbar ?? | New Users to Excel | |||
| Want to Create a List in Excel 2002; Don't see List in Data Menu? | Excel Discussion (Misc queries) | |||
| Auto filtering vs Date List Create List | Excel Worksheet Functions | |||
| Does Excel 2002 have a List>Create List option under Data? | Excel Discussion (Misc queries) | |||
Threaded Mode
