Max value across rows with multiple criteria

[Caly]

Hi! I am trying to write a formula across each row that will pull the MAX value of the Quantity in one column and then the Sales in another column and show which product it is that has the MAX value

Customers	Apple	Apple	Apple	LG	LG	LG
Values	Quantity	Price	Sales	Quantity	Price	Sales
XR model	800	$899	$719,200	422	$299	$126,178
16GB model	200	$599	$119,800	89	$89	$7,921

So for instance in the first row of the product model XR model, Apple and LG customers have their own quantity price and sales. First row would return max value for Apple, quantity 800, sales $719,200

I tried index match with max as a formula but getting error messages

The data has the Customers across the columns each with their individual quantity, price and sales in separate rows by customer corresponding to the by product model in one column

Any help will be appreciated. Thank you

 

[Fluff]

Duplicate to: Formula for First, second, third highest using index match

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.