Frequency with multiple values

jarust91

New Member
Joined
Sep 21, 2017
Messages
8
Hello,

I am trying to use the frequency formula, but with multiple values. For example:

I have 2 columns: "'Nth' Visit" and "Days between visits". In the "nth" visit it shows which number visit a certain date is for a customer. This ranges from 1 visit to 7 visits. What i am wanting to do is find the frequency that "days between visits" happen for a given "Nth visit". I was hoping to use an IF function, but haven't been able to figure it out.

The table looks something like this:

Nth Visit Days between visits
1 40
4 76
3 32
6 108
8 16
5 32
2 57
7 45
2 13
7 59
2 65

Thank you for any help that you can offer.

-Jarust91
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
I would love to do that, but I am not exactly sure what you mean Aladin, or what exactly you're looking for.
 
Upvote 0

Forum statistics

Threads
1,226,739
Messages
6,192,739
Members
453,754
Latest member
milestogo

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
Back
Top