Counting comment flags

Copper Contributor

Hi all,

 

Is there a formula to count the total amount of comment flags in a column.

 

Thanks

3 Replies

Hello @dnljns2,

 

Refer here:

https://excel.tips.net/T006932_Counting_Comments_in_a_Worksheet.html

 

Or without using VBA that could be:

press Ctrl+G > Special > Comments > Bottom of Excel workbook see "Count: #"

Thank you

@dnljns2 

 

You're welcome!