I have a excel sheet which has tables of a different vehicles taking different market routes everyday. The data available are Vehicle to the market, Opening Km and Closing Km. A vehicle may ply to two different markets on the same day or not ply at all. I want to find the opening and closing km of each vehicle every day. The sample excel file is attached.
The formula should find all instances of the name of the vehicle in the market table and get the minimum opening km and the maximum closing km to get the overall opening and closing km.
vehicle.jpg
I have tried to find a solution but couldn't find any. Please do explain your solution in brief
Thanks
Edison
Bookmarks