Hello,
I have a dataset with places and prices. I want to find which place has the highest volume among those transactions. I did that with index(mode(match and it worked, but now I want to find which area has the highest value. In other terms I want the formula to do a sumif so each place and return the place with the highest sum.
I will appreciate any help!
Thank you!
I have a dataset with places and prices. I want to find which place has the highest volume among those transactions. I did that with index(mode(match and it worked, but now I want to find which area has the highest value. In other terms I want the formula to do a sumif so each place and return the place with the highest sum.
I will appreciate any help!
Thank you!