I have a spreadsheet hundreds of rows where I need to match multiple negative values with a corresponding positive values but within multiple CATEGORIES. For example: headers in row 1, values in column B starting in row 2, and category in column A starting in row 2.....
Invoice Amount
19221 -110
19221 -100
19221 +110
19211 -210
19222 -300
19211 -210
19222 -300
19222 +300
So I need a formula to put in column C that somehow match corresponding negative and positive values within Invoice 19221 and Invoice 19222. Hope this makes sense and someone can help. Thanks.
Bookmarks