Counting occurrences of text

**Carim** · 11-21-2006, 11:42 AM

A piece of advice ...
Do not challenge VBA Noob ...
while I am still reading your question, you will get his answer ...

Carim

**Carim** · 11-21-2006, 01:12 PM

Hi,

My recommendation (as the easiest solution) would be a simple pivot table, in which you can group by the different ranges of marks ...
I do not know if VBA Noob will agree ..

HTH
Carim

**VBA Noob** · 11-21-2006, 02:23 PM

Carim is right.

I would use the extra columns instead of inserting into one cell and then use a pivot with a dynamic range.

Pivot examples
http://www.contextures.com/xlPivot02.html

Using Dynamic ranges in Pivots
http://www.contextures.com/xlPivot01.html

VBA Noob

**pinkgoldfish** · 11-22-2006, 07:31 PM

Hello,

Thanks for all the suggestions, I ended up just creating a new worksheet where I can enter that specific data and then used COUNTIF. I have another issue with a macro I'm trying to set up, if you know anything about that you can find the thread under the Excel Programming forum bit. Thanks again!

pinkgoldfish

Counting occurrences of text

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Thank you!

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions