Question description:
This user has given permission to use the problem statement for this
blog.
I have a fuels calibration table previously done in Excel. The process is to dip a long ruler into the top of the tank, hit the bottom and pull it out. The level of the fuel is then read from the spreadsheet. The current spreadsheet is broken into 1/8" increments and I must now break it down further into 1/16" increments. I am aware that Excel is not friendly to feet and inches and I have a work around. The problem is when I try to take the number of gallons from the previous sheet and populate my new sheet. The numbers go into the cells fine and I even have a formula to take the average between the two. The problem, is that with the previous worksheet in 1/8's and the new one in 1/16's I cannot figure out how to make the cells search for their data relatively on the smaller spread sheet. Any ideas?
Solved by E. E. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
04/03/2018 - 07:53
Hello there, thanks for choosing Got It Pro - Excel.
User
04/03/2018 - 07:53
Youre' welcome
Excelchat Expert
04/03/2018 - 07:53
Can you please attach your file here ?
User
04/03/2018 - 07:55
Do you work in 2013 my computer will not show the file in your upload directory.
Excelchat Expert
04/03/2018 - 07:56
I work in 2011
User
04/03/2018 - 07:58
Maybe we can do this with your open spreadsheet
Excelchat Expert
04/03/2018 - 07:58
Can you please attach and then will see if iy works
User
04/03/2018 - 07:58
It won't attach
User
04/03/2018 - 07:59
Can you see the spreadsheet on my screen
Excelchat Expert
04/03/2018 - 07:59
Yes if you can copy and paste here in google sheet
Excelchat Expert
04/03/2018 - 08:00
We both can see the data in google sheet
User
04/03/2018 - 08:01
My problem is that I have to add col b and average the two numbers
User
04/03/2018 - 08:02
I have figured out a way to expand the spread sheet to allow for the 1/16
Excelchat Expert
04/03/2018 - 08:02
To get the average of B4 and B5 ?
Excelchat Expert
04/03/2018 - 08:07
Are you there >
Excelchat Expert
04/03/2018 - 08:11
Hello ?
Excelchat Expert
04/03/2018 - 08:11
Please check in B6 cell.
Excelchat Expert
04/03/2018 - 08:11
The time is running out for us.
Excelchat Expert
04/03/2018 - 08:12
Hope we helped you, if you need our help please post again.
Excelchat Expert
04/03/2018 - 08:12
Thanks for choosing Got It Pro - Excel, please give your kind feedback for our service.
Excelchat Expert
04/03/2018 - 08:12
Have a good day ahead :)
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
