First time poster... at my wit's end here.
I have a sheet of data like the following:
A(Category) B(Sales)
Superbowl 10000
World Series game 5000
World Series game 5001
What I am trying to do is, in one cell, get the category from A with the most sales from column B, and then in another cell get the sum of those sales for that category. So essentially ranking the Categories in terms of most sales and then getting the summed sales numbers.
I have found this to be harder than it seems. I have had to go about it the reverse way - first getting the summed values with an array formula:
ex: {=Large(IF(A:A=A:A,B:B),1)}
And that seems to work. But I don't know how to then get the value in A that it is referring to!
Any ideas? Or different ways to go about it (that aren't a pivot table. I know that's the obvious answer here but doesn't work for my purposes)
Bookmarks