View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
wilchong via OfficeKB.com wilchong via OfficeKB.com is offline
external usenet poster
 
Posts: 90
Default Formular for the SECOND highest frequency

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