minor

sort out possible patterns are three = major, minor and equal detect the three colors in the corresponding color, save in the flat, please http://www.mediafire.com/file/j12ffe8e3c1e8wu/3_padroes_lotofacil.xlsx/file

Hi All, First post here, everyday i have someone go around and record the hours on a machine kms or machine hours worked (SMU) i need to build a service register. for example i have a lighting plant that needs a service every 250hrs and every 1000hrs a more indepth service, i currently have...

I have two cells F6 is a number value, L6 is text either "Personal" or "Public" I need to out put either "Very minor" "minor" "Serious" "Major" based on the values of F6 and L6 First part i tested is below but i cannot get any further as got stuck on addition checking of values in F6 and L6 and...

I need to create an average of the range below into the top box however due to the cells being both numbers and text it doesn't seem to let me use =AVERAGE() Can anyone help me get the average of my range to show into the top box. See below for range and cells. <tbody> H 1 (Formula to go...

It seems like whenever I add major gridlines to a chart in Excel 2007, the minor gridlines turn into tick marks. And whenever I add minor gridlines, the major gridlines turn into tick marks. I've even tried clicking "Major and Minor Gridlines" in the chart layout menu. But all this does is give...

Hi, I’m stumped and need help. I have a file with thousands of entries and I’m trying to add 3 columns that count the first instance of a word in that specific range. It will check for “notable”, “minor”, “test”. Column B will have ticket numbers (many of them are duplicates ticket numbers but...

regular sum = <tbody> 25,647,308,807.4172 sumif = </tbody> 25,647,308,807.4171 number formats are the same...i take the difference between the two numbers to several decimal places....Excel says "0.000000000000..." i check to see if they equal each other by A1=B1....excel says...

Hi All, I am a VBA newbie and would like some help with getting the code right background: row number of these values are never constant, ie one day row D6 might contain the keyword minor the next D65 might contain the word minor. (Refer to screenshot) goal: I want to script to search...

Hi I wonder if anyone can help please I am looking for a way to sum the number of days in a column if it meets the criteria in another column and for the life of me I cant get my head around it. So for example if it is "Category 1 - minor" in one column I want it to sum the number of days in the...

Hi, I have a continuously (once a day) updating database that looks like this: <colgroup><col><col span="5"><col span="6"><col><col span="12"></colgroup><tbody> Machine ` Minor Stops Malfunction Malfunction Type Minor Stops Malfunction Malfunction Type 1A 1 1 1 1 1 1 1 1 0 0...

Hi, I have a continuously (once a day) updating database that looks like this: <colgroup><col><col span="5"><col span="6"><col><col span="12"></colgroup><tbody> Machine ` Minor Stops Malfunction Malfunction Type Minor Stops Malfunction Malfunction Type 1A 1 1 1 1 1 1 1 1 0 0...

Hey! I'm coming a bit stuck on a formula that I'm trying to create. What I'm after is quite simple really For example column A I'll have a number, anything between 1-30 and in column B I want to populate that with "Minor" "Medium" or "Major" depending on the number in column A So 1 - 10 =...

Hi. I am hoping someone can help me with an excel problem. I’ve added a screenshot which will hopefully help explain what I’m trying to do. I would like the 2 boxes in red to auto populate. Seems simple, but I’m sure it’s not. Impact rating - this should be the highest severity based on the...