major

I'm not sure this is possible, but I thought I'd ask! Currently have a summary sheet that we have to manually change each day as a new sheet is added - the input is the name of that new sheet, and it drives an indirect formula. Its not a major pain but I wondered if I could automate this...

I have a graph that I want to go from 0 to 80000 in 10000 unit increments on my x axis. I want my data to fall not on the major tick marks (ie: a 25000, 45000, etc). How do I set this up?

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

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 There, Could someone take a look at my code and tell me how to fix it please? It's a simple code that was given to me by one of the forum members and after trying to implement it into my workbook I have come across an issue and have not been able to resolve it since. Basically I have an input...

Looking for excel formula(s) to identify major peaks and valleys. I've been using use slope combined with if, sign and vlookup to identify the peaks and troughs. My issue is there are too many peaks and troughs some of which occurring for consecutive y points. Is there a way to only show the...

Hello, I tried some vba examples but couldn't quite get the following to work. I have about 50 charts per sheet on a worksheet. Is it possible to change the y axis for the 50 sheets on a sheet with vba, without affecting the other sheets? Right now for example, I have MIN: 0 MAX: 50 MAJOR...

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...

Hello, I am a new in vba and now I want to search for duplicates in column a of all work sheets, sum the total working hours including duplicate date in column d and show sum value in other excel. Can Someone help to me and now I found someone posted the following code on this board it was...

I just discovered what I consider a major flaw in the design of the Union (comma) operator. As illustrated in the workbook here: https://www.dropbox.com/sh/v0799qr2uex4imf/AAAWi4Jhq4-vfCmuQTn4qo4Za?dl=0 The Sum function, when applied to a union of overlapping ranges, will sum the values in the...

Hi, I need the y-axis on my chart to autoscale, so that the major units will be 5, 10, whatever, as appropriate, when the values are large. But sometimes the values will be very small and the autoscale sets the major unit to 0.5. I am counting people who meet certain criteria, so this is not...

I'm looking for two different counts. First, would like to count number of entries in-between the word Major Task and then a count to exclude the "No" between the word Major Task. Results are in column C & D respectively. Data Range <tbody> A B C D 1 Hdr1 Hdr2 Hdr3 Hdr4...

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 =...

I have 2 columns of data. I need to count how many Advanced are also Safety and so on and so forth. How many Major are Safety, CD, etc. How many Advanced are Safety, CD, etc. ??? <tbody> Advanced Safety Major CD Standard PD Advanced Safety Advanced PD Major QC Advanced PD...

I want to make an Excel graph of quarterly data where the X axis has four tick marks for each year, and the major tick mark is labelled with the year, but no labels on the other quarterly tick marks.