Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Matching Values to Zero
I have sorted a spreadsheet by absolute value to match the exact
positives and negatives together. But the information is too large. So I created nested if statements incorporating "and" and "or" statements to help match the positive values and negative values. Here is a sample (x's mean a row matches with another row): 37 10650-4 1,100.90 1100.9_37 x 37 10650-4 (1,100.90) 1100.9_37 x 42 10650-4 (1,100.90) 1100.9_42 x 5 10650-4 1,100.90 1100.9_50 x 5 10650-4 1,100.90 1100.9_50 As you can see, these match correctly and show the last line +1,100.90 does not have a match. This works great, throughout some of the spreadsheet, but not everything. Can anyone help? I can email you the spreadsheet. Thanks... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching values in a row | Excel Worksheet Functions | |||
Finding Most Recent Values in Col1 -- Summing Matching Values | Excel Discussion (Misc queries) | |||
matching two values | Excel Discussion (Misc queries) | |||
matching values | Excel Worksheet Functions | |||
matching values | Excel Worksheet Functions |