Sep 21 2020 11:00 PM - edited Sep 21 2020 11:02 PM
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 a & b are launching on Mar'21, then both should be ranked same.
In addition, if the checkbox is not selected then it should not be counted in the ranking at all.
I have given a snapshot of the screen. Please suggest formula for range D18:D39.
Regards
Nishant
Sep 22 2020 01:12 AM
@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.
Sep 22 2020 01:26 AM - edited Sep 22 2020 08:01 PM
@Nishantu309034 ,,,
I would like to suggest a Non VBA method, finds Rank, and skips, if Check box is not clicked.
How it works:
=IF(J2=TRUE,L2,"")
=SMALL($M$2:$M$11,ROW()-ROW($A$1))
=IFERROR(MATCH($M2,$N$2:$N$11,0),"")
N.B.
Sep 22 2020 07:12 PM