bottom

I work with Excel a lot, but have never really had the need to use graphs. For the project I'm working on, I'd like to use some. I'd like to run the values of a column along the bottom of the graph (the X axis?), and have the values of a few other columns serve as the actual lines (the Y...

Hi guys, I am looking for ideas from the wealth of knowledge within the forum - I will try to explain as best I can but I apologise in advance if I haven't explained it well. So, I have a worksheet with three columns (there can be more if needed) the first column shows the time period...

Hello, Anyone knows a formula on how can it shows values in any row bottom when moving up or down through cells with values ?

I have three cells that calculate variances, so I want to highlight negative variances. I dont want to highlight "all" negative variances thought, but instead I want to highlight the largest variances of 3 different cells. My first attempt was selecting all cells and choosing the bottom 1...

Hi all, I have a spreadsheet that I would like to use VBA to automatically format / copy and paste certain things. The spreadsheet varies in length and currently I need to do this manually which is quite time consuming. If anyone can help it would be greatly appreciated. Copy the formats...

I am new to VBA, but trying to create a sort button at the bottom of multiple columns that will use the column location of the Macro button pressed as the column to be sorted. (Macro button at the bottom of column E would sort using the data in column E, button at the bottom of column AA would...

Once, a long time ago, I seem to remember I had an excel file that had a column of cells that could be totaled at the bottom according to the contents. If the box had anything in it, in this case either the word 'yes' or 'no' (if I got the form or just a verbal reply), the total box at the...

I can not get these two formulas to return either a 0 value or remain blank when the prior cells have not had any input entered. All I get is that #N/A. Since the #N/A is coming up, I am unable to get the column to total up at the bottom of the spreadsheet. Any help? Thanks...

Hi, Is there some vba that will look down a column of data, find the last three entries and then merge three adjacent cells, type in the word BOTTOM, rotate the text up, centralise the text in both planes, and finally fill it red with red text? Please assume the column of data has a fixed range...

When I sort my data by a column containing blank cells, the blanks go to the bottom regardless of whether I sort ascending or descending. I like that. When I have a column with a formula and the formula returns a blanks ("") in some cases, I would like those blanks to always be on the bottom...

I have a row of 6 numbers 4 4 4 3 1 1 This column has been got via ranking some other columns (Rank.EQ) formula Now i have these i want to rank the top 3 with a +1 and the bottom 3 with a -1 (the top 3 and bottom 3 numbers may sometimes be the same as in the 4,4,4, or sometimes may have...

Hello, Im currantly working on a spreadsheet with all the dates of events my work is holding for the year, and only about 50% are confirmed, I was wondering if there was a way that when i put down new dates at the bottom of the list was there a way to automatically move it to the correct date...

Hello again all, I am adding names to a table that I copied and pasted from another application. The names copied fine, however, when i added a new row to type a name i missed, then sorted the table in alphabetical order, the name i added went to the bottom of the list and not in alphabetical...

Is there a way to look down column C and remove the row and paste to the bottom if a certain name appears? ie if any cell in column C has "Totals for SELF PAY", it would cut the row and place it at the bottom and keep going down the work sheet?

Hello, What would the formula be if I wanted to find an average but exclude all zeros and exclude the top and bottom 5 percent? I know how to exclude the top and bottom 5 percent but I cant figure out how to ignore zeros.

I have been all over trying to figure this out. I attached a link at the bottom of this post to one discussion that was helpful but didn't solve my problem. I need to know how many employees I have working each hour of the day based on a 24/7 business with swing shifts and graveyard shifts...

<colgroup><col></colgroup><tbody> As new set of cells has to be copied at the bottom of existing used cells, but the VBA code below is failed (far lower than my used range), </tbody> <tbody> a = ActiveCell.SpecialCells(xlLastCell).Row </tbody> <tbody> please advise the code. </tbody>

Is there possibly a macro or a vba that can be used so that any existing excel file I go into in one click of a button it will insert a footer, bottom left, 8pt calibri, to a specific font color?

Hi, I currently have the formula below looking a set of data comprised of people and percentages. The formula currently looks at if a person is in the bottom 20% and are below the target (0.815). From this it produces either a 3 if they are both below target and in the bottom 20% or a 0 if...

I have a row that includes a Legend for the worksheet. I'd like that to print on the bottom of every page...similar to the Print Title option. Is that possible? I cannot put it in the footer...too many characters, exceeding 250 characters. Also, would like the legend cells to be used in...