PC Review


Reply
Thread Tools Rate Thread

Count values, excluding duplicates and specific values

 
 
New Member
Join Date: Aug 2011
Posts: 3
 
      18th Aug 2011
I'm creating a spreadsheet, and have (thankfully) nearly complete it. However, there is a column of values I need to count. The values contain both numbers and letters. I need to count only the unique values, and I need to exclude the cell if the value for it if it is "DOWN". Help please? I'm about ready to pull my hair out over this one.

Note: this is a spreadsheet that needs to calculate automatically on a daily basis after new values auto-fill from online databases.
 
Reply With Quote
 
 
 
 
New Member
Join Date: Aug 2011
Posts: 3
 
      18th Aug 2011
Ok, I know you guys are looking at this thread. My deadline is friday, and I really could use help. I hereby promise homemade cookies mailed to your home if you get me a working code or formula. Promise. Assuming you are in the continental US. And I also promise I'm not creepy. I'm a 21 year old female process engineer living in wisconsin, who happens to be fantastic at making your favorite cookies
 
Reply With Quote
 
New Member
Join Date: Aug 2011
Posts: 3
 
      19th Aug 2011
no cookies. I figured it out, no thanks to you lovely people.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count total values excluding some data UT Microsoft Excel Misc 6 2nd Jun 2009 08:25 PM
unique values among duplicates without considering specific words Simna Microsoft Excel Worksheet Functions 1 28th May 2009 07:19 PM
Count Duplicates in text values Madiya Microsoft Excel Worksheet Functions 6 17th Feb 2009 01:24 PM
count values not including duplicates poohtender Microsoft Access Reports 1 16th Nov 2008 04:55 PM
How do I use countif to count values excluding blank cells =?Utf-8?B?R2xlbmRh?= Microsoft Excel Worksheet Functions 4 30th Jan 2006 04:22 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:37 PM.