hello,
on sheet 1, i have a list of employee performances
column A = Date;
column B = Employee ID;
column C = Number of successful sales on that specific date
Employees are listed a number of times in column B because they have worked on many different dates.
I would like sheet 2 to have a top 5 salesman list.
in column A, i would like Employee ID with the TOTAL number of sales next to it (of course ranked from highest to lowest)
remember each employee is mentioned multiple times on sheet 1 so you would have to add all the sales they did on every date they worked.
thank you if you can help
Bookmarks