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 41 weeks ago
6 years 27 weeks ago
6 years 39 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 48 weeks ago
7 years 4 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago