Formula to calculate Frequency
Hi Everyone
I have a table of cash machines and the its usage. Grateful if anyone can any help with a formula to calculate the number of visits made by the various types of cards at each of the ATM over the period, with a breakdown of x1 , x2 , x3 , x4 , x5 , >5. Ideally I want to use a formula so that other colleagues could know how it was calculated. Please see the attached sample.
Many thanks in advance
|