maximum

[Guest]

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

 

[Guest]

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