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