Is it Possible to have an If function run the whole column of "D" that If there is a "1" in the box, it adds a different column but the same row to a box. eg ... If D9-D2000 equals "1" then add M(same Row) to M4 and O(same row) to O4 and P(same Row) to O5.
I guess i could do a different If function for each cell, but I was hoping to consolidate it into 1 cell.
I guess i could do a different If function for each cell, but I was hoping to consolidate it into 1 cell.