| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup and return any missing numbers if applicable
Is it possible to write a formula that will autopopulate a column with any
missing numbers. I believe it should be something really simple, but I can't get it to work. Example: Sheet x, column A - contains employee numbers Sheet y, column A - contains employee numbers I want to update Sheet x, column A with any employee numbers that are on Sheet y and not sheet x. Thank you in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom format applicable to negative and positive numbers? | Excel Discussion (Misc queries) | |||
| lookup range of numbers; return corresponding data for the fixed r | Excel Worksheet Functions | |||
| BIFF - Help!! lookup numbers in multiple columns and return one nu | Excel Worksheet Functions | |||
| LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
| to find missing serial numbers in randomly generated numbers | Excel Worksheet Functions | |||
Threaded Mode
