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...
I'm trying to work out how many unique customers bought a particular product. Example Below
Unique Buyers of Order
? (Formula Required)
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...
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;
Service Type (Clients can access up to 3...