Thread: possible?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default 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 ??