I have a column with Names and another with dates - how do i get my current formula to reference against the name and date columns? Basically I have to take the difference of two columns and populate it in another - the catch is that I have 2 columns that have my data in it but due to the source of the data it is on a seperate line. So I have a clock time for an employee on a day - along with their labor time on the same day but they are on seperate rows. I have my formula that will subtract the two but it only works if the data is in the same row. My current forumla is this
=IF(AND(L215>0,M215<0),L215-M215,0)
I need it to reference another row with in the same date. How could I do this? Help! Its MONTH END!
P.s This result dumps into my Pivot table that is why I am doing it this way. Unless there is a better way??
=IF(AND(L215>0,M215<0),L215-M215,0)
I need it to reference another row with in the same date. How could I do this? Help! Its MONTH END!
P.s This result dumps into my Pivot table that is why I am doing it this way. Unless there is a better way??
Last edited:
