I have posted a similar question previously, but now I am adding some additional conditions.
I am trying to figure out the following:
-
Columns A and B contain a combination of data in each row (for example row 2 Subject 112-22 + Date 11/20/2025). The same combination of data can appear between one to four times. I need to find out if any combination of data in columns D and E is matching any from A and B (for example we have a match for Subject 112-22 Date 11/20/2025).
-
Column C contains the USD amount for each subject. Please note that the same combination of data (subject + date) can have only the same amount. I need to find out which combination of data in columns D:E is Paid (if the sum/or single amount from column C is a Positive), Recouped (if the sum is 0), and Underpaid (if the sum/or single amount is a Negative). Please also note that a single combination from columns D and E can appear only once.
Thank you in advance!
