mar

Hi, I have to make some calculations using the last row of the inserted data. Need to be as formulas not macro neither VBA. Any help is more than welcome. In the next day will be more data that have to replace the ones in line 2. <tbody> total potatoes tomato apple this line should copy...

Good afternoon, I'm hoping to get some advice on a timeline slicer. I would like to exclude a specific month (or range of months) from a timeline selection, but from my attempts, it doesn't seem like this is possible within the Timeline slicer. Example: I need to know average sales for 2017...

Hi, I have 4 columns of data. Time(24Hrs HH:MM), Item,Date(DD MMM YYYY) Wish to use filter and extract data with certain criteria 1. ">=" & 20:00 Hrs 15 Mar 2018 2. "<=" & 10:00 Hrs 18 Mar 2018 Kindly support me with Macro code. I'm using the below code, but no use...

Hello all I am hoping someone can help on this I have a workbook with 13 worksheets, each sheet is named as the 12 months, IE Jan, Feb, Mar Etc and the last sheet is named as data I am looking for some vba code that when run will look at the cell value in column "S" and move each row to the...

Hi I am trying to write a formula that returns the date from a row that corresponds to the first cell in another row that is the first zero. The following example will help explain what I am mean. <tbody> Dates Column 1 Column 2 Column 3 Column 4 Jan 1 4 1 9 3 Feb 1 5 0 3...

I want formula to bring cumulative days number based on the month, need formula please. Suppose month is Mar I want from Jan to Mar 90 and remaining months Zero If month is Jun the figure from Jan to Jun should be 181 and remaining months Zero, so on so forth. Jan 90 Feb 90 Mar 90 Apr 0 May 0...

I am using this code: Sub NewMonth()' Making a new sheet with the month name changing Sheets(Format(Date, "mmm")).Copy Before:=Sheets(Sheets.Count) ActiveSheet.Name = Format(Date + 1, "mmm") Range("A2").Select End Sub From my understanding it should change the copied sheet name from...

Hi, New to this forum, so go easy. I have managed to return 4 separate values using 4 vlookups on different lines in a single cell. The purpose would be for these formula to run the entire year and show dates from the 4 other cells in the corresponding months accordingly. However when one of...

Hi all, I want to do a pill / exercise schedule for my mom, with this type of date format: <tbody> Mar 3 / AM Mar 3 / PM Mar 4 / AM Mar 4 / PM Mar 5 / AM Mar 5 / PM Mar 6 / AM Mar 6 / PM </tbody> Is there any way to quickly automate this? Thank you excellent Excelese, Ed

Hi, I would appreciate assistance creating the correct formula to : SUM columns B, D and F ONLY if there are figures greater than zero in columns C, E and G (The result to find the YTD Budget in column H) I have tried numerous with not much luck! Thanks <tbody> A B C D E F G H Jan Budget...

Hi, I have month wise data Horizontally which I want to bring vertically with formula, please help. Horizontal...

I have this block of cells in my spreadhseet numerous times. <colgroup><col><col></colgroup><tbody> Head Mar Wife Mar </tbody> Is there any way I can replace it with <colgroup><col><col></colgroup><tbody> Head Mar Wife </tbody> Without deleting each one individually?

Does anyone know how to calculate quarters in excel from a beg and end date where i am looking to seperate for Q1,Q2,Q3,Q4,Full Year? The challenge is the quarters fall between a specific range and not the usual Jan 1 to Mar 31. Every year has a different date range for Q1,Q2,etc...Then we...

Hi im trying to develop a formula to identify when a budget has been exceeded. to simplify; B10:G10 contains Jan, Feb, Mar, Apr, May, Jun B11:G11 contains 1, 2, 5, 7, 9, 5 A11 contains the budget, 7 I need the output in H11 to indicate "Mar" representing the month where the budget value...

Hi all, Hopefully a fairly easy one. Months across the top A B C D M Jan Feb Mar etc Budget 1 £1 £3 £4 £5 So if I spend £1 in Jan, £3 in Feb and then £4 in Mar - how do I...

Hi there, i am looking for a formula to enter into cells (JAN-DEC) for each row that calculates a % increase and is tied to the effective month column. Is the only solution to do multiple IF statements for each cell? Any help is appreciated. Thanks. <tbody> Core Increase Eff. Month...

Hi, I have a table that I have created pivots for and need to now create a chart from the pivot. I am having an issue due to the way my table is formatted, hopefully someone can help. Ok, my original table is laid out in this way. <tbody> jan jan feb feb mar mar apr apr may may jun jun jul...

Here is my problem I have a user form contains a ListBox that been populated from column A. It's ok fixed that. I have 3 commandbuttons (TEMP, HUMIDITY,RAIN) and one PictureBox. I'm trying to create a graph that contains x axis= Jan, Feb, Mar, Apr, May, Jun and y-axis the values from cells...

Hi everyone! I'm trying to figure out how to perform this but haven't been able to do it, so I'm turning to you since I believe you'd be able to help me with this issue. In sheet 1 I have estimated active customers for a period of time, where columns are months and rows are departments/states...

What formula can I use to sum year-to-date data when I update the "Current Month" as my criteria? Current Month: MAR <colgroup><col span="12"><col></colgroup><tbody> JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC YTD Total 100 150 150 100 100 150 150 100 100 150 150 100 ...