Hi All, Does anyone know what additions I need to make to the following formula in order for the range that is being looked at to ignore any 'Zero' value? Thanks in advance, =IFERROR(1-PERCENTRANK.INC($B$27:$B$100,$A$14,3),"")
This question generated 27 answers. To proceed to the answers, click here.
This thread is current as of March 09, 2017.