Home

Match Payments which are out slightly in rounding

%3CLINGO-SUB%20id%3D%22lingo-sub-746668%22%20slang%3D%22en-US%22%3EMatch%20Payments%20which%20are%20out%20slightly%20in%20rounding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-746668%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20large%20amount%20of%20payments%20which%20are%20we%20are%20expecting%2C%20and%20the%20payment%20received%20may%20be%20slightly%20different.%20Is%20there%20a%20way%20using%20description%20and%20amount%20to%20match%20these%20receipts%20and%20payments%2C%20even%20though%20they%20may%20be%20slightly%20different.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-746668%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-746693%22%20slang%3D%22en-US%22%3ERe%3A%20Match%20Payments%20which%20are%20out%20slightly%20in%20rounding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-746693%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F364226%22%20target%3D%22_blank%22%3E%40calof1%3C%2FA%3E%26nbsp%3B%2C%20this%20is%20hard%20to%20answer%20without%20a%20data%20sample.%20Can%20you%20upload%20a%20file%20with%20a%20few%20rows%20(please%2C%20only%20a%20few)%20and%20explain%20what%20the%20result%20should%20be%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-749076%22%20slang%3D%22en-US%22%3ERe%3A%20Match%20Payments%20which%20are%20out%20slightly%20in%20rounding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-749076%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20the%20message.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELuckily%20i%20have%20found%20a%20index%20and%20match%20formula%20which%20was%20able%20to%20work%20for%20most%20of%20the%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20time%20and%20assistance%2C%20much%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-764052%22%20slang%3D%22en-US%22%3ERe%3A%20Match%20Payments%20which%20are%20out%20slightly%20in%20rounding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-764052%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20attached%20example%20where%20the%20name%20is%20slightly%20different%2C%20but%20in%20this%20case%20they%20are%20a%20match.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20you%20able%20to%20help%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-772839%22%20slang%3D%22en-US%22%3ERe%3A%20Match%20Payments%20which%20are%20out%20slightly%20in%20rounding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-772839%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F364226%22%20target%3D%22_blank%22%3E%40calof1%3C%2FA%3E%26nbsp%3BCan%20you%20provide%20a%20few%20more%20examples%3F%20And%20also%2C%20what%20should%20be%20matched%3F%20Where%20are%20the%20payments%3F%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20this%20one%20example%2C%20the%20text%20in%20E4%20can%20be%20found%20in%20C4%2C%20but%20are%20all%20cases%20so%20straightforward%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-780303%22%20slang%3D%22en-US%22%3ERe%3A%20Match%20Payments%20which%20are%20out%20slightly%20in%20rounding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-780303%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20the%20reply.%20I%20managed%20to%20solve%20this%20use%20text%20function%20(attached).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20time%20and%20assistance.%3C%2FP%3E%3C%2FLINGO-BODY%3E
calof1
Contributor

Hi,

 

I have a large amount of payments which are we are expecting, and the payment received may be slightly different. Is there a way using description and amount to match these receipts and payments, even though they may be slightly different.

 

Thanks,

 

 

5 Replies

Hello @calof1 , this is hard to answer without a data sample. Can you upload a file with a few rows (please, only a few) and explain what the result should be?

Hi@Ingeborg Hawighorst 

 

Thank you for the message.

 

Luckily i have found a index and match formula which was able to work for most of the data.

 

Thank you for your time and assistance, much appreciated.

 

Kind regards,

Hi@Ingeborg Hawighorst 

 

I have the attached example where the name is slightly different, but in this case they are a match.

 

Are you able to help?

 

Many thanks,

 

@calof1 Can you provide a few more examples? And also, what should be matched? Where are the payments? 

 

I this one example, the text in E4 can be found in C4, but are all cases so straightforward?

hi@Ingeborg Hawighorst 

 

Thank you for the reply. I managed to solve this use text function (attached).

 

Thanks for your time and assistance.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
IIS extension is not working - WAC 1909
HotCakeX in Windows Admin Center on
11 Replies