Posted to microsoft.public.excel.programming

PhilH

external usenet poster

Posts: 1

Count unique text in cell range

In the range C5:C123, I want to count the number of times L31, L311, L316,
and L318, and blanks appear, and have the information appear like this:

L31 14
L311 24
L316 45
L318 33
Blank 3
Sum 119 (the total number of cells in the range)

How would this be done?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count unique text	shzdug	Excel Worksheet Functions	2	February 1st 07 06:16 AM
Count unique if text	Mike Fogleman	Excel Worksheet Functions	16	January 21st 07 07:47 PM
Count unique items in range	Thom	Excel Worksheet Functions	4	October 12th 06 01:13 PM
count by specific text color in range of cell	Tii99	Excel Discussion (Misc queries)	2	April 4th 06 09:58 AM
Unique count of text	Debbie	Excel Worksheet Functions	7	January 21st 05 03:53 AM

All times are GMT +1. The time now is 08:13 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us