Hi, not really sure how to go about this.
I have a data set for orders that provide the number of miles traveled, freight charge, and $/loaded mile. I'm trying to gather information to find an average freight charge in $/LM for 25 mile ranges.
Below I've included a screenshot of what my data looks like. I have 6200 lines in this data set.
I've researched the LOOKUP function, and found some good info on compiling info (i.e. what the freight charge is on order #_____) but I couldnt find anything on using the LOOKUP function to compile an average. I tried to do this with a pivot table, and also couldn't figure it out so it would give me the correct info. I could do mile brackets, but it wouldn't calculate correctly even though I indicated I wanted the average of $/LM as the value. I checked this with some of the last orders - it would give me </=$1 for some of those last orders, which made no sense to me.
I've put a snippet of the format I'm trying to get for this freight charge summary for reference.
I hope someone has some insight here, I'm lost
I have a data set for orders that provide the number of miles traveled, freight charge, and $/loaded mile. I'm trying to gather information to find an average freight charge in $/LM for 25 mile ranges.
Below I've included a screenshot of what my data looks like. I have 6200 lines in this data set.
I've researched the LOOKUP function, and found some good info on compiling info (i.e. what the freight charge is on order #_____) but I couldnt find anything on using the LOOKUP function to compile an average. I tried to do this with a pivot table, and also couldn't figure it out so it would give me the correct info. I could do mile brackets, but it wouldn't calculate correctly even though I indicated I wanted the average of $/LM as the value. I checked this with some of the last orders - it would give me </=$1 for some of those last orders, which made no sense to me.
I've put a snippet of the format I'm trying to get for this freight charge summary for reference.
I hope someone has some insight here, I'm lost