Forum Discussion
Solved
Need help counting and listing certain text in cells
Hi I am trying to show and count how many "texts" I have in a column. I did a while ago but for the life of me I can't remember. I know it's not a difficult formula. Any help would be sooo...
Thank you thank you thank you! I sincerely appreciate the help! Have a wonderful day.
Jacque
If as in your sample you may use relative reference in Ed' formula
=COUNTIF($B$3:$B3,$B3)Please check in column C attached.
Thank you thank you thank you! I sincerely appreciate the help! Have a wonderful day.
Jacque
lostinexcel , you are welcome