- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
first, highlight the entire row of first row of the section you want to flip upside down. so if you want to flip A1:G1000, then highlight row 1 by clicking on 1 on the left hand panel. then press CTRL+SHIFT+L then use the arrows that appear the change the orders to what you want
not sure if this is what you are after entirely but should at least help you out some what
As you said you cant just divide by 3 but I have divided the formula by 3 to see how many 3 months will go into the output you could maybe have another formula to divide it by 2 to see if it will divide by 2 to see if you get a whole number or not, if you do then you can just return the first part before the dot ( using split function ) and if the value is less then 1 then obviously the 3 months has not passed between the 2 dates
Hi, Cool problem I use this to track stocks for the latest 5 days, 15 days and so on.
First I have a sheet that is titled "DataRecord" this has my individual data in columns and the days recorded in rows. This is a complete record or all recorded stock activity. This is where all the entrys are made in rows. I freeze window to make the column headings and the left most column(the date) always visible to prevent errors.
Next I have a sheet that is titled "L5DaysData' I have sevreral rows of data like avg, & what ever. and the latest 5 days data starts on line say 6. a typ. cell ='DataRecord'!B970 The next cell down has a value of ='DataRecord'!B971 and so and on until B974
My Graphs are built on these individual "L5 or 15 or 60 or90 day" sheets of data.
Next I make a macro that translates the last line of data down one row and deletes the row just above the earliest that I want to save on "L5DaysData" so it always shows only the latest 5 days of information.
All the information shown on that worksheet is the data for graphs or tables refering to the latest 5 days activity. The graphs are automatically updated with the data each time the macro is run.
You can also use a formula to adjust the date column by adding a value of one to a specfic dated cell untill you reach Sat or Sun and add 3 or 2 to that date cell and translate that down a column and use a work sheet that records only the latest 3Mo. with macros that updates the information when you want it to. Hope this helps. Glad to be of assistance - please rate the solution I can learn from you. Thanks
Not sure if I get your problem. Do you mean the SUM() formula with the row does not work? That is the simplest solution if you are entering the monthly numbers per month.
If you have all these values and need to sum them up based on the current month, you need to use the MONTH() with the NOW() formulas to get a month offset and use a relative reference for the SUM() formula.