Evening Folks,
This is only my second post since joining this site and like last time i have a predicament i need help with.
I'm fairly new to Excel and i'm picking up as i go along. So heres my predicament............
I've been tasked with monitoring how long my distribution centres drivers are delayed at stores based on an average. The problem is that i have a list a mile long of all the delays we've had this year.
What i want to do is calculate an average by identifying the unique store number then ONLY average the delays for that specific store.
The form is laid out:
Column1 = Store ID No.
Column2 = Store Name
Column3 = Volume delivered
Column4 = Volume collected
Column5 = Length of delay (Mins)
So i need to indentify the unique ID (column1) and average all the Delays (column4) for that store.
Any ideas guys??
Bookmarks