+ Reply to Thread
Results 1 to 2 of 2

VBA or Marco of formula help to calculate metrics NEEDED!!!

  1. #1
    Registered User
    Join Date
    02-22-2021
    Location
    Texas
    MS-Off Ver
    Office 365
    Posts
    1

    VBA or Marco of formula help to calculate metrics NEEDED!!!

    Greetings Community as this is my first post. I hope everyone is well. I am looking for some help. I have searched far and wide for a solution and haven't come across one yet. I have a spreadsheet where there are 3 columns of data. Column A has a Date, Column B has a terminal ID and Column C has a transaction type. I would like to drop 60 days worth of data into a tab called Transactions and then calculate the following from the data. I want to be able to see the average transaction count per day per terminal and then compare that against the last time the terminal did a transaction. Can anyone help me with this? I thank you guys in advance for your assistance.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,794

    Re: VBA or Marco of formula help to calculate metrics NEEDED!!!

    It would help if you attached a sample Excel workbook. The yellow banner at the top of the screen explains how to do this.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculate average of data set using last column count
    By terriertrip in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2019, 03:36 AM
  2. Calculate average time in HH:mm
    By snuvvula in forum Excel General
    Replies: 16
    Last Post: 04-12-2017, 11:58 PM
  3. Calculate average or total count against yyy-mm-dd hh:ss column.
    By z00mer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-05-2017, 05:11 PM
  4. How do you calculate time to get an overall average?
    By chelsea7A in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-27-2017, 06:19 PM
  5. [SOLVED] Calculate time, based on transaction performed
    By ExcelUser2707 in forum Excel General
    Replies: 7
    Last Post: 03-19-2016, 05:51 AM
  6. calculate average time
    By sarinky in forum Excel General
    Replies: 3
    Last Post: 02-29-2012, 05:00 AM
  7. Excel 2007 : How to calculate an Average of a count
    By korssane in forum Excel General
    Replies: 2
    Last Post: 06-16-2010, 02:13 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1