Actually your first formular also can be worked, but one key point, I didn't
realised that the highest frequency value should be shown in the cell of H1
first. As a result, your formular show "2", which is the highest frequency
value.

Many thanks for your time!

Wilchong




T. Valko wrote:
Ok, good deal. Thanks for the feedback!

Dear Mr. Valko
I placed your suggested Excel formula in the cell of H20. The result
[quoted text clipped - 16 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