erinfleener
New Member
- Joined
- Feb 13, 2018
- Messages
- 1
Hello,
I am trying to see if there is a way (I'm doubting whether this is even possible anymore) to highlight or mark items that can offset each other exactly given certain criteria (for this purpose Project and Fund Column B and C). For example: There could be 250, 250, 500 that would 0 out with a -1000 of the same project code however there may be another -1000 that doesn't have anything it can be offset with since the only other option was already offset. In other words there are duplicates.
I already have a formula that I use that will match everything that has an exact opposite match but I was wondering if there is a way to take it a step further and match items that are not exact. I put a little snapshot of different scenarios below for better explanation
<tbody>
</tbody>
I am trying to see if there is a way (I'm doubting whether this is even possible anymore) to highlight or mark items that can offset each other exactly given certain criteria (for this purpose Project and Fund Column B and C). For example: There could be 250, 250, 500 that would 0 out with a -1000 of the same project code however there may be another -1000 that doesn't have anything it can be offset with since the only other option was already offset. In other words there are duplicates.
I already have a formula that I use that will match everything that has an exact opposite match but I was wondering if there is a way to take it a step further and match items that are not exact. I put a little snapshot of different scenarios below for better explanation
Date | Project | Fund | Amount | Match | ||
9/1/2017 |
| 1000 | -100 | |||
9/1/2017 | P0001111 | 1000 | -100 | |||
9/1/2017 | P0001111 | 2000 | 100 | |||
9/1/2017 | P0001111 | 2000 | 250 | yes | ||
10/23/2016 | P0001111 | 2000 | 250 | yes | ||
10/23/2016 | P0001111 | 2000 | 500 | yes | ||
10/23/2016 | P0001111 | 2000 | -1000 | yes | ||
10/22/2016 | P0001111 | 2000 | -1000 | |||
10/23/2016 | 2000 | 600 | yes | |||
10/23/2016 | P0003244 | 2000 | 600 | yes | ||
11/12/2017 | P0003244 | 2000 | -1200 | yes | ||
11/12/2017 | P0003244 | 2000 | -1200 | |||
11/12/2017 | P0003244 | 2000 | -300 | |||
11/12/2017 | P0003244 | 2000 | 150 | |||
11/12/2017 |
| 1000 | -10 | yes | ||
5/2/2016 | P0005555 | 2000 | 15 | |||
5/2/2016 | P0005555 | 1000 | 340 | yes | ||
5/2/2016 | P0005555 | 1000 | -105 | yes | ||
5/2/2016 | P0005555 | 1000 | -50 | yes | ||
5/2/2016 | P0005555 | 3000 | 60 | |||
5/2/2016 | P0005555 | 1000 | -175 | yes | ||
5/2/2016 | P0005555 | 3000 | 60 | |||
5/2/2016 |
| 3000 | -150 |
<tbody>
</tbody>