unique count

Hi guys! I've looked at the forum and searched but can't quite find what I want so: I have a column of names (not unique as there are repeats), a column relating to the borough they were processed in. I have been able to produce a count of the number of times each person appears in the list by...

Hello, I am hoping to get a solution to the following problem. I have a large data set see below for layout. The actual data set has about 18,000 projects and 155 + “Area” sizes, not just the 2-5 in the below. I am asked to come up with the average, min, max, and standard deviation of hours...

Hi, I am relatively new to the more complex side of excel. I hope my questions are not too simple. I am using excel 2007 on a winXP machine. OK, I have a large table holding information about products. For each product there are many columns: country, stage of development, company developing...

Hi, I am trying to count the number of unique vaules in column B that fall with in a date range in column A. For example A: B: 12/31/2009 1111111 1/5/2010 1111111 1/5/2010 1111111 5/31/2010 2222222 5/31/2010 1111111 If the date range is 1/5 to...

Hello. I need some help with an array formula to count the unique clients discharged, provided they have a discharge date in another column in the same row. I know how to do unique count, but don't know how to make it to where on the unique client #'s with a discharge date are counted (some...

I have a spreadsheet which has in one column a list of offices in Column H. In Column K there is a lst of locations. In these cells the 'location' has a value of for example ( abcdb 1234), however in a cell there may be more than one value eg (abcd 1234, xxxxx 3241,). I need a macro or formula...