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