stay

Hello, I have a problem that I cannot solve... I have a dataset that includes an "Arrival Time", an "Exit Time", and a calculated "Hours in Department". I am trying to calculate to number of visits that are currently in the department at each hour of the day. Example: I have 3 visits that...

I have converted time format from 08:30 to be 830, However when trying to change the number format from custom to general it goes to 0.3542 How do I stop it going to 0.3542 and stay as 830 in general format

Hi, how can I remove lines within each cell (multiple lines with line breaks) that are not starting with a numeric character? <tbody> 223213 - this line needs to stay chair - this line needs to be removed 9 - this line needs to stay needs to be removed </tbody> Thanks and best, Jack

I have a line graph in Excel on Mac. The size and location of the labels on the axis change based on the width of the characters included. Wider labels get slightly smaller and move up higher. Smaller labels remain larger and stay on the bottom. These are all the same number of characters...

I have a large spread sheet where some values down load to the wrong column. To fix this I am looking for a macro that can look in Column H and where it finds Balance Forward look in the same row at column J and if there is a value move that to column K. Columns L and M will have values in...

So in my spreadsheet, column A is populated with three digit numbers down to row 100. These numbers are from specific areas on a map im working on. The area numbers are going to be temporarily changed, so coloumn B is populated with the new area numbers, for the new map. Essectially, I want to...

Let's say I have two numbers in cell A1 (1,1A ) is there a way to construct a formula in B1 something like this =if(a1="1A",if(a1=1,1,"")) unfortunately they have to stay in the same cell.........the cell is used in other parts of a bigger worksheet. Thanks everybody

HI can someone help. i have a formalu below =IFERROR(INDEX('sheet2'!$A$5:$S$32,MATCH('sheet1'!B19,'sheet2'!$A$5:$A$17,0),5),"") however when i need to add/dleete some columns in sheet2 and but i want it to stay and look at the above, but when i add/delete the columns the cells it is...

Hi i'm sure this is really simple but i can't work it out i was positive numbers with a (+) and to be coloured green and negative numbers with a (-) and be red but i was 0 to stay black here is what i have so far for the formatting of the cells : [Green]+£#,##0.00;[Red]-£#,##0.00 this works...

I have two formulas that need the same function. In cell H7, I have the following formula: =IF(F7="","",ROUNDDOWN(((W47*N7)+(X47*N9)+(Y47*N11)+(Z47*N13)+(AA47*N15)+(AB47*N17)+(AC47*N19)+(AD47*N21)+(AE47*N23)+(AF47*N25))/F32*(J7/100),0)) I need to change that formula so that if cell F7 has a...

I somehow got the following corrupted language in the formula of my cells..... C:\Users\Owner\AppData\Roaming\Microsoft\Excel\ I have 2 spreadsheets that communicate with each other. This happened often a few years ago, but hasn't happened again since this past week. what am I doing wrong...

How do I get date to post in column C and stay as that date when I post something is column B?

Morning all I have the above issue when i filter on the source data How do i set the pie chart so that the original colour always stay the same? I have a area graph displaying the same data above it and that works fine Thanks

When I was using Excel 2010 I had no problems opening a UserForm in one Workbook, then selecting another Workbook and the UserForm would stay visible. That doesn't happen in Windows 10 + Excel 2016... If I open the UserForm it will hide when I change to another Workbook, and I'm loading the form...

Hi I'm trying to figure out code to copy and paste a set of formulas across a bunch of columns and then down to the end of the range. I can figure out that part with VBA, but I can't figure out how to set the formulas so that the cell references don't get messed up in VBA. It's just a simple...

Hi, My last post had a mistake. When I keep pivot and data source on same sheet I need that Pivot doesnt change when I use filter on data source. So in this case I need that when I use filter, that pivot allways stay the same (something like "stay on top") so it doesn get affected by hidden...

I have excel 2010 i have changing rows when a row is inserted. i have 2 tables. is there a way i can have my totals formula to stay the same when a new row is inserted.

All training from 0000000 to 3333333 without repetitions. Ex = 0000000 0000001 Can not have 0000100 = because it is repeating 0000001 It has to stay the perfect matrix of 7 houses

Just wondering if anyone can help!? If I post incorrectly apologises, I don't post much. I have a page called Summary(first Tab), on that page Cell B96,97,98 have rates in which change. when you change Cell B96 it changes Cell R117 to R108 on the Financial Calculations page (Tab 4) I need...

I am attempting to find a way to lock my top row, AND 8 columns on the right side of my page so that they stay locked with the top row. Any ideas on how/if this could be attained?