Min function pull down formula
 

With columns A & B, in column C a formula to pull down that will return an "m" for the minimum value of the A column "groups".

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

Thanks,
Howard

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

Min function pull down formula
 

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.

Hi Claus,

The old (MIN) array formula works well, but the MINIFS formula returns #Name?.
In the formula wizard the MINIF Function Argument box shows 'Undefined'

I'm okay with the array formula, just wondering about the MINIF.

Thanks.
Howard

Min function pull down formula
 

Hi Howard,

Am Thu, 5 May 2016 09:25:48 -0700 (PDT) schrieb L. Howard:

I'm okay with the array formula, just wondering about the MINIF.

MINIFS and other functions are in Excel 365 since the last update.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Min function pull down formula
 

On Thursday, May 5, 2016 at 9:37:22 AM UTC-7, Claus Busch wrote:
Hi Howard,

Am Thu, 5 May 2016 09:25:48 -0700 (PDT) schrieb L. Howard:

I'm okay with the array formula, just wondering about the MINIF.

MINIFS and other functions are in Excel 365 since the last update.


Regards
Claus B.

Okay, I have 2010, but the MINIF function wizard is evoked when I click on the fx in the formula bar.

Nonetheless, the array formula works fine.

Thanks Claus.

Howard