hi

i have a formula in cell d2.
and i would like to minsert in this same cell the following formula :
=IF(COUNTIF($D$2:D2;D2)=1;D2;"")

possible ??

If I understand you correctly it is not possible because you cannot have a
formula and a data value in the same cell at the same time.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"pierre" wrote in message
...
hi

i have a formula in cell d2.
and i would like to minsert in this same cell the following formula :
=IF(COUNTIF($D$2:D2;D2)=1;D2;"")

possible ??