I have a large data set linked below. In it I have user ids of shipments that have been processed. I am trying to track performance metrics down to the hour per user and its not always the same users. So my question: what would be the most efficient way to do this. And I would still like to customize it and add in conditional formatting to clean it up and make easier to read. Can I make a table or array that has user ids and the name that corresponds to it and have report pull those names based on user ids?? Any help would be greatly appreciated.
drive.google.com
EDIT:
I'm currently using sumifs (shown below) to display. but I have to go back and manually change user id in formula for each new user.
Item Transaction (26).csv
drive.google.com
EDIT:
I'm currently using sumifs (shown below) to display. but I have to go back and manually change user id in formula for each new user.
Rich (BB code):
=ABS(SUMIFS(Items!$L:$L, Items!$F:$F, "Shipment", Items!$U:$U, "Emolina", Items!$E:$E, ">=" & TODAY() + 7/24, Items!$E:$E, "<" & TODAY() + 8/24))
Last edited by a moderator:
