oh, you had me all excited there for a minute, but, when I looked, the shrink to fit box is unchecked. I took off word wrap as well, just in case that...
amyfb Yesterday, 06:35 PMAre you sure you don't have Shrink to fit on?:
...
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,"")
Change the Font Size on the displayed LOV
In which case, best attach a file where this is happening (only showing a few cells behaving this way, maybe the macro trying to adjust the font, but...
p45cal Yesterday, 06:44 PM