Will Formula work or do I need VB code when considering values from cells located in various locations?
I’m trying to find the same FA-Driver associated with different project numbers that and their combined Amounts are greater than zero.
I am basically keying in on three columns I call FA-Driver, Project No, Amount,
The sheet is sorted on FA-Driver, and Project No and sometimes I will have duplicate driver-fa values in succession but not always. They are not all duplicates.
I need to check if I do have more than 1 of the same FA-Driver amounts, with different project numbers associated and where the combined amounts associated with them are greater than zero and flag them.
Sometimes the information I need is found in the following row and sometimes I need to look at the next two or three rows (depending on how many times I have a duplicated FA-driver)
I don't know if anyone can help but I'd appreciate anything.
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago