meter

Hello In Column Meter Type I have the following formula =IF(AA2="LARGE",AND(AC2={"BASIC","MRIM"}),"Meter Requires Upgrade") What I am trying to say is that if Column Classification contains the value "LARGE" AND column Meter Installation Code Contains the value "BASIC" OR "MRIM" then mark...

I'm working on a spreadsheet which needs to populate info for an entire year. What I need the Total Meter Worked columns to do is if the end meter is a zero, to populate a zero. If the end meter has a number, then to subtract the end meter from the previous month. However, if the previous month...

I have a spreadsheet to determine the number of hours a machine worked from one month to the next based on meter readings. However, if a meter reading wasn't entered for a month (total of zero), I need the formula to go back each month until it finds a month where the meter reading is greater...

Image: https://www.dropbox.com/s/z64at5bhmo3qa2l/Image.jpg?dl=0 Hi, In the image cell E19 (Meter 5 in blue) can be changed to Meter 1 and Meter 3. Cell H19 (Meter 6 in red) can be changed to Meter 2 and meter 4. Below I gave an example on Meters 5 & 6 to show you what I need. I need a...

(Image)https://www.dropbox.com/s/2sz7hspvq6n4edk/Image.jpg?dl=0 Hi, In the image cell C14 is a drop down to determine which filling point (Meter) I need to use. In the Image 3 & 4 was selected, so Meter 3 appears in cell E19 and Meter 4 appears in cell H19. I'm going to focus on Meter 3...

Hi, I have cell C12 with a drop down list which are 1 & 2,3 & 4,5 & 6. I need that: 1. When I choose 1 & 2 from the drop down, cell E17 appears as METER 1 and cell H17 appears as METER 2. 2. When I choose 3 & 4 from the drop down, cell E17 appears as METER 3 and cell H17 appears as METER 4. 3...

Spreadsheet 1 is the list of names, dates, meter readings I have started with and I need to split the names on to new worksheets as per spreadsheet 2 Spreadsheet 1 (master worksheet) <colgroup><col width="246" style="width: 185pt; mso-width-source: userset; mso-width-alt: 8587;"> <col...

Hi I have a list of poeple that have use water. Name - Date - start meter reading - end meter reading etc. I need to seach the list via the name and then copy the Name - Date etc across to a new worksheet. Note, - name maybe listed more than once so I need to look at the complete list and...

Hello, I have a data set that can be 1500 to 2000 rows at any given month. I am looking for a vba to start at the bottom of the data and count up to insert a blank row between hour 2 & 3 (the first count is 22 then it is 26 thereafter to the top.) then change each inserted blank row to be "*2"...

Hello I am wanting to write a lookup which will bring back a value based on two conditions. in sheet 1 I want to lookup Group (Column G) and Group counter(column H) and find the long text from sheet 2 column E. (not all of the long text for each group is the same, each group counter can have...

Hello, I need help with a formula or macro(?) to provide the difference between to meter readings. The catch is I would like a running total reading ,similar to the odometer in your car, but the meter only has 7 digits, when the meter gets to 99999999, it rolls over to zeros but i need excel to...

hi all.. i have several sheets (sheet a, sheet b, sheet c. etc...) in one file ..i want extract data only cell B4,B5,B6,H42,H43 and H44 into one sheet based on the same name header.... this my layout : Excel 2007ABCDEFGH1LAND OF REPORT2JAYA CORPORATE34Name ofBulding A5Code ofXXXX6Address...

We track fuel usage using a fuel meter (much like an odometer) and use a cell data validation equation to prevent erroneous numbers from being input – a form of data quality control. If the meter reading is not the same or higher than the previous day or days, then a Stop Error pops up. It has...

Hello, I tried to search for this but had no luck. Could be just an issue with knowing what to search for. If so I apologise, can you point me to the correct place. I am trying to produce a (dynamic) list of the Top 5 Categories with their Top 5 Sub-categories and the remainder...

I have a series of meter readings sent in by field techs that tend to have finger checks & provide absolutely bizarre readings. Do you have any idea how I can identify the "Bad" meter readings using excel? .... Thanks! <tbody> <colgroup><col width="71"></colgroup><tbody> <colgroup><col...