This is my first time posting on any website, so please be gentle lol!
I am trying to figure out what forumula i need to help with the attached tabs;
Goal: to identify how many blocks are due for each block length, at each selected time for each service type. The current UI we have is really poor. this is more user friendly.
My solution?
in each cell there will be a formula to search each time slot for each service type and return the accepted amount for standard/large vehicles from the data dump CSV.
I'm self taught on excel and know some basic macros and formulas however i have admitted defeat here.
I hope this makes sense. I only need the formula to pick up one service type i can amend to suit where necessary.
Thanks in advance for those who take the time to assist.
James
Aucun commentaire:
Enregistrer un commentaire