Hello everyone.
Looking for some assistance here.
I have a list of customers with a failed purchase (column A) and I also have a list of all failed purchases in a given date range. We would like to extract all failed reasons, (code) method (type) and the amount per customer.
The expected result should list the account with failed purchases and the multiple decline reasons(code) and type he/she went through.
I have attached a sample. Your help will be much appreciated.
Regards
M
May be you need PivoteTable
I would suggest using a Pivot Table. With a Pivot Table, it's easy to move things in and out to get different views of your data.
For your example, I used Account, Type and Code for the rows and then in the "Values" field, I put both "Amount" twice, once as a SUM and once as a Count.
So, at a glance, you can see that IB18490 had 4 issues with Cash totaling 200 and 1 issue with crypto for 0 amount.
Does this fit your criteria?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hello Guys. Thank you for your answers, perhaps I didn't express myself correctly.
We need to list only the accounts in column A that appear in the all failed purchases. Columns (C:M)
In other words if the account in column A appears in (C:M)list the Code, type and amount of all their purchase attempts.
let me know if that is clear.
Okay, I assumed Col A was a list of all accounts but I see now there are accounts in your table that are not in Col A. In your original data, I added (Col G but you could do it in B or O) a test to see if it's in Col A. I used this formula
=COUNTIF(A:A,F3)>0
Then in the pivot table, I added Col G (which I called "Col A") to a filter and Filtered only on TRUE. This gives you results only that are Column A
Hello ChemistB
Thank you for your help.
This one does meet my criteria. I really appreciate it.
M
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks