•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Is there a way to make the "Range" within a formula only use cells with certain data in
Our take
Are you looking to rank customer sales by product while keeping your data organized in a single table? If so, you're in the right place. The RANK.EQ function can help you achieve this, but you'll need a way to make the "Range" selective based on customer numbers. By utilizing criteria within your formula, you can ensure that RANK.EQ only considers sales associated with the specific customer in the current row. This approach allows you to maintain a comprehensive dataset while accurately reflecting individual rankings.
So I have a table with customers and their sales by product.
I want to use RANK.EQ to rank each customers sales by which products had the highest sales value.
I want to do this while keeping all customers in the same table but the rank only takes into account the products under their customer number.
I believe RANK.EQ would work, IF there is a way to make the "Range" selective, so have the Range be the customer number column, but have it only look at customers with the same customer number as the row it is currently looking at.
Is there a way to achieve this?
Thanks
[link] [comments]
Read on the original site
Open the publisher's page for the full experience