Re: Counting unique accounts

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Dave Peterson (ec35720_at_msn.com)
Date: 05/28/04 

Date: Thu, 27 May 2004 19:32:00 -0500

You could add another column to your pivottable range.

I put my years in A2:a1000 and my customers in B2:b1000.

Then I put this in C2 and dragged down:
=IF(SUMPRODUCT(--($A$2:A2=A2),--($B$2:B2=B2))=1,1,0)

It puts a 1 in the first unique occurence row--else it puts a 0.

Kyle Putzier wrote:
>
> I've got a list of all of the sales for the last 8 years. I'm getting better at using Pivot Tabls to analyze the data, but I haven't figured out a way to count the number of unique account sold to per year. How can I do this?
>
> Kyle 

-- 
Dave Peterson
ec35720@msn.com

Relevant Pages

  • Re: How to control the loop within expect.
    ... set timeout 100 ... set::customers 0 ... puts stderr "GOTCHA" ... this will stay inside till close or a thief comes along ...
    (comp.lang.tcl)
  • Re: Red herrings
    ... Puts a whole new spin on ... making advances to customers. ... district enjoys such a mild and balmy climate that people think nothing ...
    (uk.media.radio.archers)
  • Re: mighty mouse
    ... better if the market simply puts up with it. ... But Apple's customers are voicing their gripes with the Mighty Mouse directly on Apple's web site: ...
    (comp.sys.mac.system)
  • Re: Sync Subform with Mainform
    ... This does add the customers contact first name and customers contact ... last name to the combo box, but it puts the name for the currently ... displayed customer next to all of the ticket IDs (even the ticket IDs ... How can the tickets subform display something from ...
    (comp.databases.ms-access)