I have a list of 111 rows, each one containing different information, including a dollar amount. I also have a number that some (but not all) of those dollar amounts total to. Is there a macro, or some other way, that can automatically search through the numbers to see if any of them total the number I enter? I would also like it to remove duplicate amounts that total 0, for example $1,000 and ($1,000).
I've attached an example.
The main thing I am trying to accomplish is to weed out the duplicate amounts (where one is positive and one is negative), and use the remaining amounts to see if any of them total a certain number, in this example it is the highlighted number in row 116 (256,227.00).
Let me know if I can provide you with any other information that may help. Thanks for looking!
Bookmarks