transaction

Hello Experts, I am having trouble in calculating a the 'final value' column in the below table. Imagine you have a text column 'sample_card' which has multiple transactions over a month. Now, a particular card is eligible for one txn per day only. Maximum discount VALUE PER TXN is set at 75...

I have a spreadsheet where the columns are (A)operator (B) time of transaction (C) transaction type. The same operator can be listed up to 200 times in the spreadsheet. I need a way to calculate the operators total time (Last transaction minus first transaction). I have 50 operators within the...

Dear Experts I want a table in which the No of Currency received/given to be record in a cell like for 1000 Note 1000 4 500 200 100 . . if i receive 1 note of 1000 rupee then i write 1 in front of 1000 rupee cell if i receive another 1000 rupee note then i write 2 in front of 1000 rupee...

Good morning All, I am trying to write a VBA to search for either a PO# or Document # and from that return Additional information. I have a workbook with 2 tabs that this would work with 1st Tab is "Transactions" -- PO # would be -Column "X", Document # is column "V" 2nd Tab is...

Hi folks, I want to do a pivot table based on credit card transaction data that is categorized - obviously the raw transaction data won't make for a very good pivot table since it's not categorized... When downloading a credit card stmt in csv I get transaction data something like below (blank...

Hi all, I want to run a query which identifies the number of transactions conducted per account per hour and the amount. my table have 3 columns A: Account Number B: Transaction date & time C: Transaction Amount I have searched the forum q's but didn't see anything relevant so far. So...

Hello I am trying to have a consistent numbering between tables since I am trying to have a consistent numbering of a general Operation ID that is present on all the tables (that number is like a transaction ID but its present on different tables because there are different types of...

I need to determine the age of a transaction from a historical standpoint. Normally I would use =TODAY()-A1 However, I have to produce historic data and when entering this formula, I'm getting the data as if it were today. Example: I have a payment date of 11/23/2018 and need to calculate...

I have a table of transactions that include Date and Customer ID. How can I find for a transaction, the next transaction for the same customer? For example, a customer might have several transactions over several dates. If I look at any one of those transactions, I need to find the very next...

Hi, I'm stuck with a particular kind of formula in excel. I'm looking to calculate the average amount of days it takes for a transaction to be completed for each month. I have a sheet listing when all the expressions of interest and the date/time that this occurred and another listing when the...

Hi Excel experts, I am trying to concatenate text with time. But it is not working. For example <tbody> FOM MY ECC Staging Margin Transaction Daily 01 -Cell 1 <tbody> 0:50:52 - Cell2 Output is coming as <tbody> FOM MY ECC Staging Margin Transaction Daily 01 0.0353240740740741 I...

Hi Everyone, I am no VBA expert and appreciate any help you can provide. I would like to learn how to search for a before and after instance to copy and paste information in between those two instances. And then repeat the process. This helps to create a format usable for a pivot table. For...

HI, I have a power query table with payments made on a transaction. I would like to have all payments on one line for each transaction so I can link them to the sales table. But if a customer paid with 2 credit cards in power query it is listed on 2 lines. I was hoping to use the un pivot and...

Hello, I have a file with records which include transaction dates. I want to grab the last transaction date in every month and assign it as a statement date. I used an array function to implement this and it works. Below is a small sample that illustrates the idea. The formula in B2 is as...

Hi, am looking to find help for the following problem. I have 2 Sheets: Sheet 1: Columns B, C & D. Column B is the Stock Status (Either "No change" or "Change in Stock"). Column C is Transaction ID 1 (e.g XXX2342) and Column D is Transaction ID 2 (e.g XXX2341). Sheet 2: Columns D, E. Column...

Hey all. I have a program that outputs the data in a fashion that makes it hard to use without the graphics, this in turn makes it hard to convert to a usable CSV. The fun thing is the headers for the data also does not always line up. I was wondering if you guys could help think of a way...

Hi All: I'm trying to calculate the average transaction time and need some help. The data is arranged with the transaction number in column A and the time each item in the transaction was scanned in column B (think supermarket scanner). For example if I had a transaction with 8 items, the...

I have a spreadsheet which I need to modify a bit with a much more complicated formula. Hoping someone can advise. Here's the existing formula in C2. <tbody> Classification Revenue Jan Feb Mar Apr Conv Date New Business $500K if(ConvDate>C1,0,B2/12) Jan 15 Upsells $1M Feb...

Hi, Please could someone help me some match the data in columns 'Transaction Number' and ;Line Description': <colgroup><col><col><col></colgroup><tbody> Transaction Number Transaction Line Description Date Rejection for Invoice 5-Nov-18 Miscellaneous_Negative_Entry_For_NEW...

I need to get a CXXXXX code into column A for every line that I have in my data table. Some of the rows already have the code in column A. In other rows accross columns B - F I have 1 of 2 possibilities: (a) the CXXXXX code in column D, and/or (b) a transaction code in columns B or F...