View Single Post
  #13   Report Post  
RagDyeR
 
Posts: n/a
Default

Could you please elaborate on your statement "non robust formula", in
relation to using ROW(A1)?

I'm always willing to learn.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"Aladin Akyurek" wrote in message
...
Why insist on ROW(A1) for it makes a non-robust formula?

Ragdyer wrote:
One way,

=IF(ISERR(SMALL($I$3:$I$34,ROW(A1))),"",SMALL($I$3 :$I$34,ROW(A1)))