Just out of interest, a shorter version of the formula in msg#1 for more recent versions of Excel:
=SUM((INDEX(I2:FD273,SEQUENCE(272),SEQUENCE(,51,1,3))="")*(INDEX(I2:FD273,SEQUENCE(272),SEQUENCE(,51,2,3))=FX13)*(C2:C273=FZ11))
In cell N3:
=IF(L3=MAX($L$3:$L$13),J3,"")
=IF(L3=MAX($L$3:$L$13),K3,"")
=IF(L3=LARGE($L$3:$L$13,2),J3,"")
Hello!
I have a list of values that displays in a very tiny font size, smaller that the size of the values in the list itself.
I...
This has been cross-posted here: https://www.mrexcel.com/board/thread...mbers.1205474/
...
Change the Font Size on the displayed LOV
Are you sure you don't have Shrink to fit on?:
p45cal Today, 03:03 PM...