Related:
- Sorry, this feature isn't available right now: an error occurred while processing this request. please try again later.
- Network error occurred - Guide
- Mimecast an error has occurred. try again to complete the process ✓ - Network Forum
- Sorry, this feature is not available right now! yahoo - Yahoo Mail Forum
- Submit request free fire - Guide
- Unable to complete request. please try again later ✓ - Facebook Messenger Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Oct 22, 2015 at 11:03 AM
Oct 22, 2015 at 11:03 AM
in my opinion, most efficient and simple way would be have two additional columns where merchant, account and amount are combined (one for "from bank" and one "to bank"). then you can use match formula and match the value
Oct 22, 2015 at 11:15 AM
Both sets of data are not in any particular order. I want them matched so that each matching items for "sent to bank" and "processed by bank" are on the same row ( so I can clearly see they match). I also want the unmatched items t be pushed down to the bottom of the list so they can carried forward to the next day. Please advise.
Thanks,
VSK
Oct 22, 2015 at 11:36 AM
Oct 22, 2015 at 06:04 PM
Thank you for the clarification. Yes "Match" does work well. I am just wondering could we have a macro to sort the results of the match formula in ascending order? This would enable me to have the matching item for "processed by bank" on the same row as the item in "Sent to Bank". Please advise.
Processed by bank Column Sent to Bank Column
A - Merchant M - Merchant
D - Card # O - Card #
E - Card Type N - Card Type
G - Amount T - Amount
Formula in Column AD =A2&D2&E2&G2 (to combine merchant. card, type and amount for "Processed by Bank")
Formula in Column AE ="200-0"&IF(LEFT(M2,3)="OMS",MID(M2,4,8),MID(M2,3,8))&O2&N2&-T2 ( (to combine merchant. card, type and amount for "Sent to Bank")
The results of MATCH formula are in Column AF
Please advise. Thanks in advance for all the help. Appreciate it!
VSK