thanks for ur fast prompt!

=AND(COUNTIF($AK:$AK,$AK2)=1,ISTEXT($A2)
i use inside validate function for comments right? [cant work :( ]
or inside cell? [if inside cell, then i cant use CONCATENATE already]



"Roger Govier" wrote:

No, it is not the same.
I have used Absolutes on the column letters.
Try it and see.

--
Regards

Roger Govier


"kyoshirou" wrote in message
...
Hi..

wasnt urs the same as =AND(COUNTIF(AK:AK,AK2)=1,ISTEXT(B2)) ?

however, both also cant works.

any tips from here?


"Roger Govier" wrote:

Hi

Then maybe
=AND(COUNTIF($AK:$AK,$AK2)=1,ISTEXT($A2)


--
Regards

Roger Govier


"kyoshirou" wrote in message
...
Hi Roger,
I mean:
i have a column AK. This column data is computed by forumula
CONCATENATE
(from columns A,B,C,to AJ).
Next, i would like to check there is no duplicate CONCATENATE data
from
columns A,B,C,to AJ. For this i used
=AND(COUNTIF(AK:AK,AK2)=1,ISTEXT(A2)
The error prompt out wont work.

Does it sound blur?

(haha)
Thanks!


"Roger Govier" wrote:

Hi

I misunderstood what you were trying to do originally.
Reading back through the posts, doesn't Dave Peterson's suggestion
work
for you?

If not can you post back with some more detail about what you have
in
each of the columns and exactly what it is you are trying to
achieve.

--
Regards

Roger Govier


"kyoshirou" wrote in message
...
Any tips again?

"kyoshirou" wrote:

Or to make it simple, how to do i check there is no duplicate
CONCATENATE
values inside 1 column?

"kyoshirou" wrote:

can i do a validate in a way so that the
Total value of all rows from column A,B &C is not same from
Row
1.

Any ideas?