I have a question,
I have a tracking sheet that tracks decision and dates, this sheet feeds into a mater workbook that has s decision and decision date columns.
The problem/question is, that there can be reschedules, appeals, etc so there could be more than one decision date (in the tracking sheet). In some situations there may just be ONE decision, in others there can be two or three.
I need the master tracker to only pull the final decision and date (so I would need it to look in all columns and only pull the latest entries)
The tracking sheet looks like this
Decision Date 2
Decision Date 3
This question generated 16 answers. To proceed to the answers, click here.
This thread is current as of May 14, 2015.