bottom

In the Excel Questions forum I replied to a post, thanking that individual for a solution, but my reply appeared under someone else’s post later in the thread. When the cursor hovered over the Edit button at the bottom of my reply, it said “Edit/Delete”, but when I clicked it, I did not see an...

I have a 3 row tall signature block that is inserted 4 rows below the bottom of a dynamic table. I want to insert code that will ensure that the signature block never gets printed between 2 pages. I'm looking for code that will find the location of the last hpagebreak, compare it to the...

Hi, I have a spreadsheet where I need to locate the bottom-most cell that's value is NOT 0 - however there is a possibility that the value we are looking for is numerically below 0. I found; LOOKUP(9.999999999999E+307,IF(Q1:Q300>0,Q1:Q300)) Which locates the bottom most cell with a value that...

Hi, This has been asked a lot but I can't adapt solutions to my needs. I need to rank by brand the top & bottom variance but only if the sales & plan <> 0. Sample data below with expected results <colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody> Brand Sales...

Hi everyone, I am just getting into Excel and VBA so please excuse my stupid questions. I have a really long excel sheet which is filled from bottom. There is a date columns well as other specific data rows. My issue is I want to open the excel sheet with the last (bottom) row visible. Not a...

Hi All what is the best way to find a specific value called Leaver in say range (A2:A50) and cut the entire row when found and paste it to the bottom deleting and blank cells in between? my aim is to ensure that i have all leavers at the bottom of the data

I have a spreadsheet with lines that get inserted into a table. At the bottom I have signatures that need to be pushed down if the new lines added to the table reach them. Is there a way to make the signatures remain stationary until the lines meet them and then get pushed to the bottom of the...

Hey guys, I've been racking my brain trying come up with 2 separate macros: macro 1) toggle cell border between borders: top, bottom, left, right, outside, top and double bottom, none macro 2) toggle cell interior color between: yellow, light gray, light blue, no fill I tried using the "case"...

Hi all, There are 4 areas in a pivot table, the one on the bottom right called the VALUES AREA, is where it sums (or other calculations) I have two columns in that field - sum of QTY, and sum of Revenue All I would like to do is, within each Category Subtotal (defined by groupd in the Row...

I want to determine how many rows back (from bottom) of a range that you have to go, to find the first value that meets a condition (condition might be >, <, or =). The values in the range are not sorted. So, if A1:A8 contains: 1, 10, 100, 45, 75, 200, 5, 88 These are the answers i want...

How do I get rid of the small navigation arrows in the bottom right of each header field in a table?

What is the vba code I can add to a button to delete last row from a table?

It is getting where I have so many tabs on the bottom of my spreadsheet that they are kind of hard to find. I am using excel 2016. Is it possible to place a second row of tabs on top of the existing row to make them easier to see, or perhaps any other creative ideas instead of having to create a...

I have a column of topic scores. Around 50 cells. I am trying to highlight the bottom 5 and top 5. There are about 10 of these topics that are on a reverse scale meaning a lower score would actually be better and could put them in the top and a higher score would be worse and could put them in...

Hi I need to have an full screen image shrink to around 25% of its original size and appear in the bottom right corner. The shrink/zoom animation only seems to be able to put this centrally, which, unfortunately, is no use!

Hi, Need vba formula to do the following 1) Sheet(Week1),Range(B13) if IDnumber exist, then in I13 update formula to get the vlookup value from Week2 sheet(A:E,5,0)" 2) This should be done from bottom of last row to up in Sheet(Week1). Please advise. Thanks, Shiva

Hello, I was wondering if there is a way to jump to the bottom of a cell range if you have blanks in between. Please see my example below, as I would like to get from 5 to 4 in one shortcut. I know Ctrl + down arrow goes to the end of the cell range if there are no blanks, but was hoping to get...

I am copying the following; <colgroup><col><col><col span="2"></colgroup><tbody> 411040356 <form id="form" action="./InvoiceSummary.aspx?InvoiceId=54388053&Context=Inbound" method="post">CARLSON 1-11 </form> 411040366 <form id="form"...

This comes up all the time. I have a table that I have carefully highlighted with borders. If I add a row in the middle, everything is good. But if I add one at the top or bottom, I get an extra top or bottom border. Is there any way to add a row at the top or bottom of a table with a border and...

Hi! I have a slightly strange request and it’s been a long time since I’ve really got deep into Excel formulae. Although this is specifically for Google Sheets so hopefully it’s possible on that too. So I have a list of people and dates that will be added to from time to time. Once a persons...