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