ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   possible? (https://www.excelbanter.com/excel-discussion-misc-queries/189688-possible.html)

Pierre

possible?
 
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 ??

Sandy Mann

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 ??





All times are GMT +1. The time now is 05:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com