#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
Cross post. other username http://www.excelguru.ca/forums/showt...late-Frequency
http://www.excelforum.com/excel-form...frequency.html
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need a formula to calculate turnaround time | Rockitman31 | Excel | 9 | 09-07-2015 09:41 AM |
IF Formula to calculate dates | Sophie1 | Excel | 2 | 04-23-2014 07:19 AM |
Formula to calculate Date and Time | funkyfido | Excel | 2 | 06-25-2013 04:25 PM |
Formula to calculate Leap Year | USAOz | Excel | 2 | 09-11-2011 04:58 PM |
What formula should I use to calculate commission? | grs | Excel | 3 | 02-21-2011 02:17 AM |