Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / February 2008

Tip: Looking for answers? Try searching our database.

count unique fields

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
megz12 - 08 Feb 2008 16:29 GMT
In a row I have 4 to 5 unique fields, that can appear in more than 1 column.  
I have a function to count all the text fields but I would like them
separated into unique counts.

Exp:  blue red  green  red  red  blue  green green = how many red, how many
green, etc.  I would like each result in a different cell.

Thanks I am sure this is simple, but it doesn't seem to be working out.
FSt1 - 08 Feb 2008 16:43 GMT
hi
countif....
=countif(A1:G1,"red")

you will need a countif forumula for each unique value.

Regards
FSt1

> In a row I have 4 to 5 unique fields, that can appear in more than 1 column.  
> I have a function to count all the text fields but I would like them
[quoted text clipped - 4 lines]
>
> Thanks I am sure this is simple, but it doesn't seem to be working out.
megz12 - 08 Feb 2008 16:53 GMT
Thanks, that works great!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.