Forum Discussion
Nishantu309034
Sep 22, 2020Copper Contributor
Avoid ranking duplicates in excel, checkbox to avoid ranking
Hi all, I want to rank the products based on their launch month and year. But in case, any 2-3 products are launching in the same month, I want to club them into a single rank. For e.g. if product ...
Riny_van_Eekelen
Sep 22, 2020Platinum Contributor
Nishantu309034 Created a small model, roughly based on the example in your picture. It demonstrates what you need to do. Used a few helper columns to keep the formulae easier to read and maintain.
- nishantlakshyaSep 23, 2020Copper ContributorThanks a lot. Let me check and confirm if it works for me.