Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=max.if.group doesn't work - so how I can...
....do it in some other way?
Example: This kind of function work for me: =average.if.group(H:H;D:D;"running") It specified cells includes word "running", then it counts arithmetics average between those numbers. But if I want to find out like same way, which is the highest number between those specified cells - it doesn't work like that. I'll be very grateful, if someone have solution for that? - Anssi - |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
=max.if.group doesn't work - so how I can...
=MAX(IF(H1:H65000="running",D1:D65000,""))
This is an array formula, so you need to press Shift+Ctrl+Enter to enter it, not Enter. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Anssi" wrote: ...do it in some other way? Example: This kind of function work for me: =average.if.group(H:H;D:D;"running") It specified cells includes word "running", then it counts arithmetics average between those numbers. But if I want to find out like same way, which is the highest number between those specified cells - it doesn't work like that. I'll be very grateful, if someone have solution for that? - Anssi - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add a group or filter to pivot table from another sheet or work bo | Excel Discussion (Misc queries) | |||
Copy Data from One Group of Cells to Another Group | Charts and Charting in Excel | |||
Taking age group Ie ages 20-29 and picking out net sales for group | Excel Worksheet Functions | |||
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions | |||
How do I protect sheet, but allow "group" function to work | Excel Discussion (Misc queries) |