maximum
 

I have a worksheet with a column that contains customer name and one that has
customer purchases. The customer name may have several lines since there are
multiple purchases. I have the customer list in another worksheet that only
shows each customer one. I have a column that references the sumif of all
transactions of the customer and a column to countif the name matches and I
use these to get the average. I now need to provide the MAX and Min for the
group of customer transactions. I don't know if there is a way to vlookup
the name of the customer with a max function built in or if I should use the
large function. The customer purchases are listed by date of purchase for
the month so they are not grouped together, hence the sumif function. Any
suggestions?

Thanks

maximum
 

See if this works for you (adjust the ranges to fit your needs):

=MAX(IF(A1:A100="Customer 1",B1:B100))

This is an array formula, and should be entered with CTRL-SHIFT-ENTER
instead of just Enter. If done properly, the formula should be enclosed in {
}.

HTH,
Elkar


"Dale" wrote:

I have a worksheet with a column that contains customer name and one that has
customer purchases. The customer name may have several lines since there are
multiple purchases. I have the customer list in another worksheet that only
shows each customer one. I have a column that references the sumif of all
transactions of the customer and a column to countif the name matches and I
use these to get the average. I now need to provide the MAX and Min for the
group of customer transactions. I don't know if there is a way to vlookup
the name of the customer with a max function built in or if I should use the
large function. The customer purchases are listed by date of purchase for
the month so they are not grouped together, hence the sumif function. Any
suggestions?

Thanks