Count Comments

[StevenFrost]

Hello,

I'm using Excel 2010 and have a spreadsheet with lots of different comments in, which are free text in response to an open question (none of the comments are likely to be exactly the same).

Could you please let me know of a formula to count the total number of columns in a column?

Thank you,

Steve

[dilipandey]

Hi Steve,

welcome to the forum.
I believe there is no standard function available in Excel for this and the only option is VBA (macros) UDFs.

Regards,
DILIPandey
<click on below * if this helps>

[Tony Valko]

Maybe this...

Comments in column D.

=COUNTA(D:D)

[Andrew1983PL]

Hi,
Paste in module please:

Please Login or Register  to view this content.

Regards
Andrew
Moderators note: code tags added for you - this time

[dilipandey]

Not sure if Steve meant to count the comments entered in the cell OR to count the text values entered in the cell(s)





Regards,
DILIPandey
<click on below * if this helps>