return value help

[Peter1973]

I am using the formula :

=IF(COUNTIF(AE:AE,AR$6)<ROW(A2),"",AR$6)

Is there any way a formula could then return me the value in the relevant cells in column AF , I cant use a standard lookup as in the range will retunr more than 1 of the same value, hope this is clear if not let me know.

cheers

Peter

 

[Joe4]

I think your formula got cut-off, as it looks incomplete. Try enclosing it in code tags. I think it is mistaking some of your greater than/less than signs for HTML code.

Also, could your provide a small data example to describe exactly what you are trying to return?

 

[Peter1973]

Thanks your right here is the whole thing :

=IF(COUNTIF(AE:AE,AR$6)<ROW(A1),"",AR$6)

 

[Peter1973]

DONE IT AGAIN 3rd tme lucky

"IF(COUNTIF(AE:AE,AR$6)<ROW(A1),"",AR$6)"

 

[Peter1973]

One more try

IF(COUNTIF(AE:AE,AR$6)<ROW(A1),"",AR$6)

 

[Peter1973]

This is trying my patience last try

if(countif(ae:ae,ar$6)
<row(a1),"",ar$6)

 

[Peter1973]

Does anyone know why this wont let me post anything else other than the first 2 lines have tried typing it on seperate lines

 

[Joe4]

Peter, as I mentioned in my previous post, try using code tags.

To do this, type in your formula, highlight the whole thing, then click on the Code Tags icon from the editor menu (looks like a number sign or pound sign).

 

[Peter1973]

I may be blind but where is the editor menu ?

 

[Joe4]

When you reply, do you click the "Post Reply" button, or on the "Post Quick Reply" button?

If you click "Post Reply", right above the edit box where you type stuff in, you should see a bunch of icons above the edit box, and a bunch of smilies to the right of the edit box. If you do not see these, you have have elected different default settings in your Profile.

You can manually type in the Code Tags also. Just type in the word CODE enclosed in square brackets just before the start of your formula, and the word /CODE enclosed in square brackets just after the end of your formula.