Good Morning All,

I do apologise if this has already been answered however I couldn't find it anywhere.

On a daily basis I need to match up two sets of data for employee performance.

Basically I have a list of all employee numbers and export the results from another piece of software but this only displays the employee's who have results and not all.

Is there a quick way of matching this data? a function that says if a1 does not = b1 then move b1+c1 down a cell?

Thanks for your help