return value help

[Peter1973]

here goes :

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

 

[Peter1973]

One last time

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

 

[Peter1973]

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

If this doesnt work think im giving up

 

[Peter1973]

Nope tried the

 at the start and

at the end no joy.

 

[Peter1973]

got an idea am just going to type it in between my writing so here it is without the equals sign if(countif(ae:ae,ar$6)<row(a1),"",ar$6) lets see if this works.

 

[Peter1973]

I have give up that didnt even print all my typing I have never had this before.

 

[Joe4]

Odd thing. If I hover over your thread from the Excel Forum, I can see the beginning of your original question and the formula you typed. It looks like this is what you wanted to type:

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

The offending character is the greater than sign. That is being confused for the start of HTML code. Here is another little trick to get around that. Just put a space before and after the greater than sign, i.e.

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

At this point, your original question probably has been garbled among the formula posting problem you were having. If you like, I can move this thread out of this forum (to the About This Board forum), and you can post your question again from scratch so that it appears as a brand new unanswered question. Just let me know.

 

[Peter1973]

Thanks that would be good.

 

[Joe4]

I have moved this thread to the "About This Board" forum (since it deals more with posting on this board now that it does the original question).

Please feel free to post this question again on the Excel forum.

Note, if you want to make sure that you can post this formula without any issues, I would recommend using the "Test Here" forum first to try it out. You can use that Forum whenever you want to test posting something out first before posting it for real.