I need to match one or more values in Column A with one value in Column B. Ideally highlighting the matched values, but any method of referencing the matching values would work. The attachment shows where I have manually matched the two columns using different colours for the matched figures.
Thanks all
Picture1.png
Last edited by Jaribu; 10-07-2023 at 04:53 AM. Reason: Add picture
Matching the sum of a non specified amount of non consecutive numbers with numbers on another list... unless the list is small it will be almost impossible to do.
How long is the list?
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
I suspected so as I can't find any solution.
Max 100 lines each instance.
Yeah, I don't know how you'd do that. In theory, you could have MANY combinations of debits that could add up to a credit, and one debit could be used in combination to many credits so there's no way to color code them because it could match several.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks