Getting cell index from cell to the right

[RagDyeR]

You're a little redundant with your sheet references.

Once per reference is sufficient, and can shorten your formula a little.

ALSO - Do you realize that your Countif() trap goes to Z1000, while you're
only polling to Z50 in the If() portion of the formula.
Typo ? ... Or what?

Without the extra sheet references:

=IF(rt=0;"";IF(COUNTIF(Sheet1!$B$3:$Z$50;rt)>0;INDEX(Sheet1!$B$2:$Z$2;MAX(IF(Sheet1!$B$3:$Z$50=rt;COLUMN($A:$Y))));rt))

--

Regards,

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




Btw,

I'll definately use the last code you posted with the minor sheet reference
changes as this is beautiful (if you can say this about code, hehe):

=IF(rt=0;"";IF(COUNTIF(Sheet1!$B$3:Sheet1!$Z$1000;rt)>0;INDEX(Sheet1!$B$2:Sheet1!$Z$2;MAX(IF(Sheet1!$B$3:Sheet1!$Z$50=rt;COLUMN($A:$Y))));rt))

Take Care RagDyer,
Thank you

 

[Pontus]

Thats great, didn't know you could remove thouse...

thanx.

 

[RagDyeR]

Glad you finally got everything working right.

Appreciate the feed-back.