| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Function for select data which NOT exist from the list
Here's a small sample file that demonstrates this:
xExtractMissing.xls 15kb http://cjoint.com/?fcepu2wnPz -- Biff Microsoft Excel MVP "wilchong via OfficeKB.com" <u43231@uwe wrote in message news:8386ef316b61a@uwe... Hello Biff, I have checked with my Excel spreadsheet and confirmed to you that the "calculation" in spreadsheet is set "Automatic"! The formula still doesn't work exactly! Thanks, Wilchong T. Valko wrote: The formula works. It sounds like you might have calculation set to manual. Make sure calculation is set to Automatic: ToolsOptionsCalculation tabAutomatic Thank you Biff. The formula is working, however, the formula ONLY list "D" from cell C3 to [quoted text clipped - 23 lines] Many thanks, Wilchong -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DATA VALIDATION LIST- CAN I SELECT FROM LIST WITHOUT SCROLLING | Excel Worksheet Functions | |||
| Function to select random values from a list. | Excel Worksheet Functions | |||
| how do you select these data from a list? | Excel Discussion (Misc queries) | |||
| What function to select the last 3 small values from a list ? | Excel Discussion (Misc queries) | |||
| What function to select the last 3 small values from a list ? | Excel Worksheet Functions | |||
Threaded Mode
