Morning everyone!
I have a question regarding the Rank Formula. I am using this formula;
=RANK('Pet TPL log'!BV3,'Pet TPL log'!$BV$3:$BV$511,1) - but it returns #Value!
The column I am trying to rank is a formula field that will contain numbers like 1.1, 2.5, 2.4, 5.1 etc
Is there a problem with what I am doing here?
Thanks as always
Gavin
I have a question regarding the Rank Formula. I am using this formula;
=RANK('Pet TPL log'!BV3,'Pet TPL log'!$BV$3:$BV$511,1) - but it returns #Value!
The column I am trying to rank is a formula field that will contain numbers like 1.1, 2.5, 2.4, 5.1 etc
Is there a problem with what I am doing here?
Thanks as always
Gavin