Thread
:
Getting the 2nd largest or smallest valuesin a range
View Single Post
#
5
Michael Rekas
Posts: n/a
Thanks Ken
I like it!
Regards
Michael
On Sat, 29 Jan 2005 15:14:22 -0000, "Ken Wright"
wrote:
=SMALL(IF(A1:A100,A1:A100),2) array entered using CTRL+SHIFT+ENTER will
ignore 0s and blanks
Reply With Quote