I am an accounting clerk, trying to reconcile an account. So, I have a list
of debits and credits for an account, and I'm trying to "tick and tie", or
balance, the account. For example:
A B
1 Debits Credits
2 10
3 25
4 33
5 41
6 55
7 58
8 41
9 65

My example is simple to balance since I can cross out the 25 and 33
balancing out with the 58. My problem is with an account ledger that has
500-1000 entries on it and trying to find which debits match which credits.
If anyone can help me with a fuction or macro or anything, I'd appreciate it!
For example: "what cells/values in column A equal 65"?