Rank Formula in Excel
Everyone, thanks for all the help. I have another question. I have been trying to understand this formula I have been given but I can not understand all the parts.The formula does work wonderfuly. I use it to rank certain cells. Here it is:
I understand the rank portion but....would someone kindly tell me in simple terms what the COUNTIF part does? That is where I get lost. Again I know the formula works as I want it but I don't understand it and a friend of mine is asking me what this part of the formula is for.
Answere: Hi, Thi first part gives you the rank within the list. However if there are more than one of that specific entrys they will all have the same rank. The second part counts the number of equal entries following in the list. That way all entries will get a unique rank. _ "Fair Winds and Following Seas