Problem. IF with COUNTA Function

[vijay.vizzu]

Dear All,


I have a sheet with repeated items, so i entered countif formula to get unique count of items without repeatition, so i entered =IF(COUNTIF($J$11:J15,J15)=1,1,"") in cell C11. It works fine, but now in another column i entered =IF(J11<>"",COUNTA($J$11:J11),"") to give serial numbers for cell C11. but when i copy the formula to below cells, it counts formula cells also and wherever formula cell appears it counts but not showing any figure and in next cell it counts. like it appears 1,2,3,5,7 (4,6 are the cells which contains countif formula. So how to resolve this. I don't want to delete countif formula which is in cell C11.


Thanks in advance.

 

[vijaySharma]

Is it possible for you to upload your file?


~VijaySharma

 

[vijay.vizzu]

Thank you vijay Sharma, but sorry to say this i can't upload my file due to some IT restriction. Sorry for incovenience caused

 

[Luke M]

Change your COUNTA function (which counts both text and numbers) to just a COUNT function (counts only numbers) and that should solve your problem.

 

[vijay.vizzu]

Thank you Luke... it works fine

 

[Luke M]

Glad to help.