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