Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 388
  • Last Modified:

Get number of distinct items in list with formula - excluding blanks

Hi experts,

I'm trying to get the count of distinct orders per sales rep in the attached file. That formula should work with or without blanks in the sales rep column.

As the table on the Report tab changes size, I'd like to refer to it by table ids rather than by ranges.

Thanks for your help,

Thomas
Copy-of-Daily-Sales-Today--6-.xlsx
0
nutsch
Asked:
nutsch
1 Solution
 
NBVCCommented:
Try:

=SUMPRODUCT((Sales_Line[Salesperson]=B7)/COUNTIF(Sales_Line[SO No.],Sales_Line[SO No.]&""))
0
 
nutschAuthor Commented:
Perfect, thanks.

Thomas
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now