How to add Countif formlua to an Excel column


#1

Hi all
I have an excel sheet which has a column UiD - i need to add CountIf formula to the entire column - any suggestions other than the Hotkeys method??

Thanks in advance…


#2

Hi,
if column UiD index is constant , you can use excel template where formula defined in template !!
//RJ


#3

Hi @shaileshpathak,
Here i have attached a sample that to add the custom formula . May be it helps you.

File : AddCountifFormluaToAnExcelColumn.zip (8.9 KB)

Regards
Balamurugan.s


#4

Hi @RAJU_KADARI - You mean, i Write the formula in one Excel template and later write that to the existing Excel sheet ??


#5

@balupad14 - i need to add =Countif(B:B,B2) - when i use the approach you suggested it doesnt really help me in writing it to the cell.


#6

yes, store excel in perticular location and when you writing to excel just copy to other location and write datatable :slight_smile: