unique clients

  1. F

    Client List with most recent contact

    Hi, I am having trouble with INDEX and MATCH, I have an appointments "all appointments" report from a CRM that I am trying to determine last contact date. I have already created the new table and created a unique member ID list but I'm stuck on the formula for identifying most recent attended...
  2. E

    Count Unique Customers Who Order Using Formula

    Hi All, I'm trying to work out how many unique customers bought a particular product. Example Below <tbody> Product Orders Unique Buyers of Order Bouncy Castle 56 ? (Formula Required) Trampoline 32 ? <tbody> (Formula Required </tbody> Inflatable Pool 77 ? <tbody> (Formula Required)...
  3. S

    Pivot Table Calculations

    Hi Guys, I have about 600 rego numbers for which I need to figure out below. 1) Difference between minimum & maximum odo reading for unique rego numbers 2) Days between minimum & maximum odo reading for unique rego numbers Below is an example of my data with 4 rego numbers I thought Pivot...
  4. P

    HELP - Unique Clients / Sessions report in Excel

    Hi All, I have a excel sheet of Raw Data, which shows the different sessions that have been delivered to various clients. Each row contains the following information (There are additional fields too):- Unique Client Reference Number; Client Name; Service Type (Clients can access up to 3...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top