Excel 365 is a very different program, so
Code:= LET( multiplicity, COUNTIFS(numbers, numbers), distinct, UNIQUE(FILTER(numbers, multiplicity>1)), INDEX(SORT(distinct,,-1), k) )
Try,
[F2] =LARGE((COUNTIFS($A$2:$A$14,$A$2:$A$14)>1)*($A$2:$A$14<(IF(F1>0,F1,99^99)))*($A$2:$A$14),E2)
E2:E4 = 1,2,3
Thanks for your support.
I am using Microsoft Excel 2007. whenever i change value in column my excel get hang & re-open.
Please suggest.
Thank for letting us know your version. Would not know a reason why it hangs.Thanks for your support.
I am using Microsoft Excel 2007. whenever i change value in column my excel get hang & re-open.
Please suggest.