Count Unique Records

E

Erinayn

Here is our scenario example:
When an order is placed we open 8 tickets relating to that order that need
to completed and we categorize it by business region and tickets on a summary
sheet. We'd like to add a field to the summary that gives the number of
orders placed by business region.

Since our reporting gives a line item per open ticket (up to 8 lines) I'm
not sure how to get the number of orders with open tickets.

I'm assuming frequency but by adding the second criteria I'm not getting a
correct formula.

Any help would be appreciated.
 
G

Gary''s Student

If you have a column with some duplicates and want to count uniques:

=SUMPRODUCT((H1:H1500<>"")/COUNTIF(H1:H1500,H1:H1500&""))

for column H, for example
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top