-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
moment
-
V
Formula to convert the reported moment of production into the shift(s)
<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hello, I work for a production unit, whose activity is organized in two shifts of 12 hours (the 1st one- 7:00-19:00; the 2nd one- 19:00-7:00). In the attached table, the...- vladimiratanasiu
- Thread
- formula moment one- production time
- Replies: 4
- Forum: Excel Questions
-
S
Axis automatically adjusts if no value
Hi there On my spreadsheet I have the dates going along the bottom. What I would like is if there is no value next to the date then for the axis to adjust ie at the moment I have months in there from Jan 17 to Dec 18, as there are only values in from Jan-Dec 17 at present, I want the axis to...- surkdidat
- Thread
- axis jan moment month technically
- Replies: 0
- Forum: Excel Questions
-
F
Countif in VBA
Hi guys, I have a named table ACR_tbl, I would like to count all the times #N/A appear in the table. If the number is greater than 0 I would like to pull up a MsgBox as a warning. At the moment I am doing this (to an extent with COUNTIF(ACR_tbl,NA()) ), is there a simple way to do it via VBA?- Fredek
- Thread
- extent moment table vba warning
- Replies: 5
- Forum: Excel Questions
-
Forum subscriptions not working
I used to have subscriptions to several sub-forums: "About this board", "Lounge", "General Excel discussion", which generated each day an email with a report of new posts. It partially stopped working some time ago. At the moment I only get a summary of "About this board", the other two...- J.Ty.
- Thread
- board moment subscriptions summary working
- Replies: 0
- Forum: About This Board
-
E
Conditional Formatting =TODAY()
Hi all, I am trying to get a status in my data to show different colours for delivery dates that are in L10 down, the status being in P10 down At the moment I have CF for the following =TODAY()>L10 = Red =TODAY()<L10 = Orange =TODAY()=L10 = Green For some reason if there is nothing in L10...- ExcelRoy
- Thread
- =today l10 moment p10 status
- Replies: 3
- Forum: Excel Questions
-
X
Max value across multiple sheets and corrosponding ajacent cells
Hello. I have multiple sheets with results of diffrent loadcases. Every sheets has 4 columns. A - node , B - Moment (M), C - Normal (N), D - Shear (Q). I want to make a summary of the results in one resultsheet where it shows Maximum Momement (M) and its corresponding Normal and shear. IE. If...- Xuseen
- Thread
- found moment sheet sheets vlookup
- Replies: 0
- Forum: Excel Questions
-
A
Increase row value of formula as formula dragged across columns.
Hi, I have the following formula: =INDEX(Sheet1!$B18:$AT18,MATCH($AA2&$C2,Sheet1!$B$4:$AT$4 & Sheet1!$B$7:$AT$7,0)) When I place it into next column, I want it to look like this: =INDEX(Sheet1!$B19:$AT19,MATCH($AA2&$C2,Sheet1!$B$4:$AT$4 & Sheet1!$B$7:$AT$7,0)) and down a row (which works...- alocke
- Thread
- excel formula moment row works
- Replies: 3
- Forum: Excel Questions
