gas

I want to calculate inches for the number of gallons filled in a tank so I need a formula for that. Tank size = 6000 Gallons Size = 96 * 192 1 inch can have 16 gallons (I need a formula for that). For example, if my tank contains 1000 gallons, how many inches is that?

Hello all, I am looking for an excel formula which would pickup from whole data , here with attached data for your reference. Data available in columns like from Jan to Dec and output i dont want to show everything in one go so only selected months need to be shown in output summary. which...

What would be the best way to create a lookup table for my expenses. If A2 contains X then it pulls from the lookup table. Example. <colgroup><col><col></colgroup><tbody> Expense Category Vons store Grocery Mail chimp Advertising Cheveron gas Auto </tbody>

I need a total SUM of each Category in Column C based off of corresponding amounts in Column D. I also need the SUMS for each Category automatically updated to a separate table. <colgroup><col width="49" style="width: 37pt; mso-width-source: userset; mso-width-alt: 1568;"> <col width="115"...

Hello Everyone, I have a large list of addresses that have heat system types associated with them. I want to be able to get it into a format where it is just the town name and a total number of each heat type. I would normally do this manually but there are over 1 million addresses in this...

I wonder if someone can help me with some VBA code to get totals? I will be able to write code to sort the columns according to column B (Description). I would like to first insert a row at the end of each Col B category. Then have the totals of all Col C (debit) and D (credit) calculated for...

I'm new to Access (moving over from Excel because the databases were too big) and I was wondering the best way to duplicate how excel manipulates data. I have two tables that need to interact: Table 1 - Gas Component Percentages in a sample (Methane, Ethane, etc.). Each sample processed is a...

Hello Excel Gurus, I am having some difficulty and looking for some help. I am trying to pull together an expense report from several different locations. Unfortunately not all of the locations have the same accounts or are in the same order. I have compiled a list of the accounts on sheet 1...

SUMIFS difficulty...need help with a lookup type formula, probably not even a SUMIFS? Finding or matching Lease Number, Period, and title of E1:J1, I want to output whats in my next tab appropriately. Unfortunately that next tabs data dump does not have the dates in the same format, hence they...

I have a spreadsheet set up as: date utility units used cost 7/2/2016 gas 122 $94.86 7/12/2016 electric 98 $100.00 2/15/2017 water 99 $56.87 2/20/2017 gas 120 $122.25 4/28/2017 electric 147...

Hey Everyone, I am new to MrExcel & Excel itself. I apologize if this can easily be accomplished o/r has been asked before. I am trying to create an Excel sheet for Employee's to keep track of a Company Vehicle. Specifically, Mileage & Gas level. However, the problem I am running into is...

I need a google sheet to have the same functionality that my excel workbook has but the code doesn't work on google sheets. there are 4 columns (Date, Location, Location, Location) when a value is updated in a location column I need the date cell in that row to update with the current date...