Thread: Excel Function for select data which NOT exist from the list
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.newusers
wilchong via OfficeKB.com wilchong via OfficeKB.com is offline
external usenet poster
  
Posts: 90
Default Excel Function for select data which NOT exist from the list
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

Reply With QuoteReply With Quote