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...
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)...
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...
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...
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.