I'm wanting to know how to report a figure from one column, when the data changes in another....So my example is in column A I have a list of jobs that change every so often (in the first case its the same from row 2 to row 27, then changes at row 28) what do I need to do to report the value in cell D28 when it sees a change in column A?
Any help is really appreciated
Link to file Example Data.xlsx
Cheers
James
Any help is really appreciated
Link to file Example Data.xlsx
Cheers
James