Hello - I need help to sort multiple columns for Vendors, hours their employees worked in a week for us, and the latest date (for the latest week they're reporting). Please see the attached file. Column K is where I need the formula for each vendor. For example, I highlighted in light blue what I'm looking for and the answer to populate in the K column. For vendor A, the answer should be 30. Thank you in advance.
10.7 KB Views: 2