I hope someone can help me with this
I get a #VALUE response from Q5 to Q29, the formula in these cells is
=RANK(P5,$P$5:$P$29,0)
I dont have figures in P5-P29 yet as I am waiting for data from D5-O5 to populate it.
=IF(COUNT(D5:O5)>=3,SUM(LARGE(D5:O5,ROW(INDIRECT("1:"&MIN(6,COUNT(D5:O5)))))),"")
When I get enough data (3 cells) in D5-O5 I lose the #VALUE response I had expected to get, but I do not want to see the #VALUE on the sheet.
Is there a way of not showing this #VALUE reponse, it all works OK, but does not look as clean as I would like!
Thanks
Jeff
Bookmarks