Beneindias
Board Regular
- Joined
- Jun 21, 2022
- Messages
- 120
- Office Version
- 365
- Platform
- Windows
- MacOS
Hey again, guys.
I have a new problem, that I can´t get to the solution after trying a lot of formulas, and being stuck to this for a day.
So, I have an excel file where I compare several quotes to make a decision.
I have spaces to compare nine quotes, but I don't always get nine, leaving some blank.
Thats where my problems begin.
I'm trying to have them ranked with a formula, but I'm not able to ignore the blank cells and they end up being ranked as well.
I have this formula:
=IF(J32;RANK.EQ(J32;($J$32;$O$32;$T$32;$Y$32;$AD$32;$AI$32;$AN$32;$AS$32;$AX$32);1)+COUNTIF($J$32:J32;J32)-1;"")
This one takes care of repeated rankings and all that, but it does not take care of blank cells, considering them the first ranks.
The cell that shows the ranking stays blank, but it is still ranked and I need this formula to completely ignore blank cells
Thanks to all of you
I have a new problem, that I can´t get to the solution after trying a lot of formulas, and being stuck to this for a day.
So, I have an excel file where I compare several quotes to make a decision.
I have spaces to compare nine quotes, but I don't always get nine, leaving some blank.
Thats where my problems begin.
I'm trying to have them ranked with a formula, but I'm not able to ignore the blank cells and they end up being ranked as well.
I have this formula:
=IF(J32;RANK.EQ(J32;($J$32;$O$32;$T$32;$Y$32;$AD$32;$AI$32;$AN$32;$AS$32;$AX$32);1)+COUNTIF($J$32:J32;J32)-1;"")
This one takes care of repeated rankings and all that, but it does not take care of blank cells, considering them the first ranks.
The cell that shows the ranking stays blank, but it is still ranked and I need this formula to completely ignore blank cells
Thanks to all of you