Find and count unique values

**famico78** · 06-24-2009, 08:48 AM

I have a spreadsheet that holds customer information. What I want to do is find how many customers there were last month. I have a cell (C1) which has last month displayed as 2009/05. A1 holds the customer ID and B1 holds the date they used us. Each customer may has used us many times and I'm having a nightmare trying to solve this.

Please help.

**NBVC** · 06-24-2009, 08:50 AM

So you want to know how many times a date was entered for the particular month, or how many times dates were entered once for each customer for the month?

**deadlyduck** · 06-24-2009, 08:57 AM

If I understand you correctly, you're looking for the number of unique customers during the month.

This formula might work:

Please Login or Register  to view this content.

where a1:a150 is the range of customer ID's (I'm assuming a customer's ID is unique to each customer)

UPDATE: APOLOGIES- I THINK IT'S NOT CORRECT

**famico78** · 06-24-2009, 09:00 AM

If 10 customers used us 5 times there would be 50 entries for the month. So, how many customers used us in the month.
I hope that makes it clearer?

**NBVC** · 06-24-2009, 09:07 AM

Try:

Please Login or Register  to view this content.

Where A1:A50 contain customer names and B1:B50 contain dates...

edit ranges to suit and confirm formula with CTRL+SHIFT+ENTER not just ENTER

**famico78** · 06-25-2009, 11:16 AM

Many thanks

**leedsfinest** · 12-04-2009, 08:17 AM

Hi!
I am using a similar formula to count the number of different unique values within any given date (so Month and Year are relevant), How can I use the Count(1/Frequency.... formula achieve my calculation?

Any help is greatly appreciated.

Thanks!

**leedsfinest** · 12-04-2009, 08:20 AM

Don't worry i've sorted it!! Thanks!!!

**DonkeyOte** · 12-04-2009, 08:23 AM

leedsfinest, we're obviously glad you resolved your problem but going forward if you have a question please ask in your own thread - if you feel another thread is especially relevant provide a link to it in your post.