K
kgemind
Working with Excel 2007, we start with a status report of pre-populated
columns and rows of data. Multiple agents independently update the rows that
are assigned to them, while leaving the unassigned rows blank. When all
agents complete the assignment, we must combine their work into the master
worksheet, then delete duplicate rows. What excel function would combine
these multiple worksheets? Any way to easily delete the duplicates?
columns and rows of data. Multiple agents independently update the rows that
are assigned to them, while leaving the unassigned rows blank. When all
agents complete the assignment, we must combine their work into the master
worksheet, then delete duplicate rows. What excel function would combine
these multiple worksheets? Any way to easily delete the duplicates?