Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Max If function
Ron,
The below formula works in case column A has text value. If my col A has numerical value , how can i write the formula to find max value in Col B ??? =MAX(INDEX((A2:A10="Dog")*B2:B10+(A2:A10<"Dog")*M IN(B2:B10),0)) Thanks in advance BK |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Max If function
Hi,
You question isn't clear to me but if you are trying to find the maximum value in column b which for a given numerical value in column A then =MAX(IF(A1:A10=1,B1:B10,"")) This should be array entered. Press Shift+Ctrl+Enter -- Thanks, Shane Devenshire "BK" wrote: Ron, The below formula works in case column A has text value. If my col A has numerical value , how can i write the formula to find max value in Col B ??? =MAX(INDEX((A2:A10="Dog")*B2:B10+(A2:A10<"Dog")*M IN(B2:B10),0)) Thanks in advance BK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ISBLANK function not working when cell is blank dut to function re | Excel Discussion (Misc queries) | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |