Find & change subsequent duplicates to FALSE

[Pienuts]

Hi, all!

I have a large sheet with, after a boatload of formulae, a TRUE or FALSE returned in column AZ. I thought I was finished, but apparently there cannot be two TRUEs with the same value in column D. I need a formula to keep the FIRST true event true, and change all the duplicates to false.

It would be preferred to do this without VBA, as my network doesn't enjoy it.

Thanks for your time!

 

[yogeshmaney]

can be please provide data sample

 

[Pienuts]

Sure!

http://www.4shared.com/document/av8LDJiT/duplicate_help.html

 

[ISY]

Hallo
Enter the following formula may be translated into Range AZ20:

=SE(CONTA.SE($D$1:D20;D20)=1;VERO;FALSO)

 

[Pienuts]

Okay, I've figured it out.

Thanks to ISY for the inspiration.
I made column BB display the non duplicatable number for only the TRUE rows [=IF(AZ12996=TRUE,D12996,"")], and then I used this formula:

=IF(AND(AZ2=TRUE,IF(COUNTIF($BB$1:BB2,BB2)=1,TRUE,FALSE)),TRUE,FALSE)

Thanks for your help!