AN11 = L11 - M11
Used =IF(L11=0,"",L11-M11) to forward blank cell to make AN11 a blank cell.
Problem is that AO11 returns this #Value!
Function in AO 11 is:
=RANK(AN11,$AN$1:$AN$15)
The problem gets trickier as there are values in the column that are positive (5) and (0) and negative (-11) etc. This makes using a formula such as:
=IF(Z11=0,0,Z11+AB11)
undesirable as it returns 0's which in turn causes issues when I plan to use this formula in column AP.
=MATCH(SMALL(AO:AO,ROW()),AO:AO,FALSE)
So far this is the most complicated issue that I have come across ... I have looked through help on Excel and am having a hard time finding any function that resolves this one.
Thank you for your assistance with this issue,
Leonard
Bookmarks