| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Obtaining Max and Min Values with Sumproduct
Is this possible? I have a data set of 4,000 lines and want to extract the maximum and minimum values for Criteria3, where the conditions for Criteria1 and Criteria2 are met. I would be grateful for any assistance tm -- Timmy Mac1 ------------------------------------------------------------------------ Timmy Mac1's Profile: http://www.excelforum.com/member.php...o&userid=15188 View this thread: http://www.excelforum.com/showthread...hreadid=477898 |
|
#2
|
|||
|
|||
|
Obtaining Max and Min Values with Sumproduct
=MIN(IF((A1:A10="a")*(B1:B10="b"),C1:C10))
entered with ctrl + shift & enter do the same for MAX -- Regards, Peo Sjoblom "Timmy Mac1" wrote in message ... Is this possible? I have a data set of 4,000 lines and want to extract the maximum and minimum values for Criteria3, where the conditions for Criteria1 and Criteria2 are met. I would be grateful for any assistance tm -- Timmy Mac1 ------------------------------------------------------------------------ Timmy Mac1's Profile: http://www.excelforum.com/member.php...o&userid=15188 View this thread: http://www.excelforum.com/showthread...hreadid=477898 |
|
#3
|
|||
|
|||
|
Obtaining Max and Min Values with Sumproduct
Cheers Peo. I get lost with array formulas and much prefer Sumproduct. But I guess sometimes you can't avoid them :) thanks again -- Timmy Mac1 ------------------------------------------------------------------------ Timmy Mac1's Profile: http://www.excelforum.com/member.php...o&userid=15188 View this thread: http://www.excelforum.com/showthread...hreadid=477898 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
