Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
PULL Function | Excel Worksheet Functions | |||
What function in a formula will pull the text used in a Tab name? | Excel Programming | |||
PULL FUNCTION | Excel Worksheet Functions | |||
PULL function | Excel Worksheet Functions |