Write cell error (formular)

[fairymemay (noona)]

I want to write formular in excel

formular = =IF(COUNTIF(C$2:C2,C2)>1,“Y”,“N”)

But error as below.

[lrtetala (Lakshman Reddy)]

Hi @fairymemay

Try this

"=IF(COUNTIF(C$2:C2,C2)>1,""Y"",""N"")"

No need to use .ToString at last

[Parvathy (PS Parvathy)]

Hi @fairymemay

Try this:

"=IF(COUNTIF(C$2:C2, C2) > 1, ""Y"", ""N"")"

Hope it helps!!

[fairymemay (noona)]

@Parvathy After write cel.

I want to value text not formular.
How to solve it?

l

[fairymemay (noona)]

I have more question.

If I want to use column name in cell that write (write in column name = Check_remark)

How to write it?

[lrtetala (Lakshman Reddy)]

@fairymemay

You have to give column Index like

“C”+counter.ToString

[fairymemay (noona)]

It’s can’t use column name right?

[lrtetala (Lakshman Reddy)]

@fairymemay

yes, it can’t take column name

[lrtetala (Lakshman Reddy)]

@fairymemay

FYI, There is another approach

So, it writes total rows in C Column without using for each