Min function pull down formula
Hi Howard,
Am Wed, 4 May 2016 22:23:58 -0700 (PDT) schrieb L. Howard:
So for the three 123's the min is 4, so an "m" in first row of column C.
The three 125's min is 1 so the third row down in C would have an "m".
The one 126 is a non-dup so it too would return an "m" in column C
123 4
124 2
125 1
123 5
124 5
125 3
123 6
124 8
125 7
126 4
if you work with a new Excel version Try:
=IF(B1=MINIFS(B:B,A:A,A1),"m","")
else:
=IF(B1=MIN(IF($A$1:$A$10=A1,$B$1:$B$10)),"m","")
The second formula is an array formula to insert with CRTL+Shift+Enter
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|