Dear Mr. Valko,
Many thanks for your suggestion. However, the result showing "0" after array
entered the formula. How come it will happen in this way?

Thanks,
Wilchong

T. Valko wrote:
One way...

Array entered** :

=MODE(IF(A1:E1<H1,A1:E1))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

If there isn't a "2nd mode" the formula will return #N/A.

Dear sir,
I have an excel formular which involve 5 cells, A1, B1, C1, D1 and E1. The
[quoted text clipped - 11 lines]
I hope you can advice me on this. Many thanks,
Wilchong

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200903/1