showing

Hi, I'm trying to find an empty cell, then return the cell 1 before it, then the cell 2 before it, then the cell 3 before it, so that my summary page is always showing only the last 13 headers. Any idea on what this formula would be? Thank you in advance!

Could someone help me with this problem. I have a sheet named "Employee Print Outs". It is set up to print out 32 pages. Page 1 starts in cell B6 and ends in cell S154. Page 2 starts in cell B155 and ends in cell S304. So each of the 32 pages has 150 rows of printing area. What I'd like to...

Hello, Please i need your help anyone. I have a multiple sheet containing transactions from different client and a colum showing revenue for each of this client. I will like to get the total per client on each sheet separately.

I'm using Excel for Mac 16.8. Since the last update my comments aren't showing on mouseover, although this is selected in preferences. Any ideas please?

I am mapping my car mileages. The car was first registered in late 2011 but the chart is showing from the start of 2011. Any ideas how I can fix it?

Code is ... Sub TENREPEAT() WAITME.Show ("WAITME" is a userform with a picture) For i = 1 To 10 Call RandomNumbers Next i WAITME.Hide --------------------------------------- code is running in the background but Userform not showing Picture until I activate VBA Editor Please...

Hi, I have 10 columns, in Column A I have the formula =today() so, this shows todays date. In column B I have the formula, =A1+1 (showing tomorrows date). I need to do this across all columns with column A always showing the current days date. The main issue is that as we go across the...

Hi, can anyone tell me how to get the delta symbol to stop showing up as a capital D? Thanks, Rick

Hello All, the negative duration in this table isn't showing in the chart. Date range is at the top, task name is vertical axis Sheet1 <tbody>#cacaca[/URL] "] B C D E #cacaca[/URL] , align: center"]5 Task Name Start End Duration (days) #cacaca[/URL] , align: center"]6...

Hi everyone I am new to VBA and struggling with creating coding to hide and unhide rows based the selections in my dropdown list. I went through a lot of tutorials and couldn't find a suitable one to do exactly what I want. I have a dropdown list in cell D1 with three options namely 1,2 and...

i have inserted GIF . animation is not showing can any one help me out here is the anmation link https://media.giphy.com/media/IkJjTk438wR4k/source.gif

<tbody> A B C D E F G H I J K L M N 1 12 21 13 31 14 41 15 51 2 3 013 578 569 589 015 378 016 278 4 124 245 014 256 237 045 127 389 5 457 689 236 478 126 156 349 056 6 679 023 125 367 459 489 238 167 7 8 9...

Type: Excel Question Sub Type: Time Format Issue Description: I am extracting data from this tool, and I am getting this error, where Minutes are Showing up as Hours. They are not being converted. They are literally being moved to hours. Example: Value - 0:10:00 = 10 Minutes It is showing as...

I am writing a triple IF statement that reads =IF(A1="X","SG3",IF(B1="X","SG2",IF(C1="X","SG1",""))) the formula works for putting the SG3 where i want it to go, but i am getting an error in the other 2 cells. Any ideas as to why the cells that are not true are not showing up as blank?

I have some data and need to count the cells that are showing the number 1 in them for each row. The actual values is not 1, but that is the value displayed in the cell. Column G should contain the count for the cells showing 1. For the data I will post below, Cell G1 should say 1, G2=2, etc...

I have built the PivotTables from the data and then PivotCharts from them. My "PrimaryValueAxisTitle" is showing on the wrong data; displaying on the Secondary axis side. And my "SecondaryValueAxisTitle" is not displaying at all. I do not get any error messages. Got any ideas...

Morning All, I have a table with data showing on it and a small graph underneath it showing what the table is above. Due to size restrictions on this i am unable to show the graph in a decent size so wondered how i can get the graph to go full size when "Clicked" and for it to go back to normal...

Morning All, I have a table with data showing on it and a small graph underneath it showing what the table is above. Due to size restrictions on this i am unable to show the graph in a decent size so wondered how i can get the graph to go full size when "Clicked" and for it to go back to normal...

Hi, First of all apologies if I've not titled this correctly (it might be why my days of searching have returned nothing). I have two columns of data one showing storage locations the second showing invoice numbers. What I'm trying to achieve is a way to find out how many times any location is...