mar

I have a workbook with 2 separate sheets for each month of the year. Some formulas are long (ex: =IF('SAL FEB 2019'!H12>'SAL FEB 2019'!E7,'SAL FEB 2019'!E7+'SAL FEB 2019'!H12+'SAL FEB 2019'!B7+'SAL FEB 2019'!G12-'SAL FEB 2019'!G3,IF('SAL FEB 2019 '!G12+'SAL FEB 2019'!B7>=0,'SAL FEB...

I have a list of data from Jan 2014 - Dec 2018. Is there an easy way to use conditional formatting so all the Jan,Mar,May,Jul,Sep,Nov are filled Gray while Feb,Apr,Jun,Aug,Oct,Dec are Blue? Thanks!

I have a sheet that is formatted similar to this... Jan Feb Mar Item 1 2 3 5 Item 2 1 4 2 I need it to format like this for an upload... Item 1 Jan 2 Item 1 Feb 3 Item 1 Mar 5 Item 2...

Hi team, I am trying to do the following. I have a cell A1 that has a dropdown of months (jan, feb, mar...) and that has a name of 'date'. In another tab I have a cell that I want the text to change depending on the month selected in the first tab. So if Jan, Feb, Mar, or Apr is selected I...

Hi I have excel 2013. I want to consolidate date from 3 different sheets using pivot table not data-->consolidate tool. so i created these 3 tables and insert Table1, Table2, and Table3. I was inside Table3, I clicked insert Pivot and checked Allow Data Model. In pivot table, I created...

Hi everyone, I'm sure this is simple but I can't find the solution online. Is there a way I can use a MID formula like this that follows this, unless there is a space, in which case it stops earlier? I have text, for example: <tbody> Tue, Jul 31 09:38:21 BST 2018 and Tue, Mar 6 14:26:37...

I have a table with Months across the columns and warehouse and items down the rows. I am trying to automate an upload file and need it in a format with warehouse, item, Month and quantity...is there a way to do that with a pivot table? See simplified example below... Table looks like this...

Dear all. I have been working on for a while with a sum issue that I simply can't find a solution to. I whant to be able to SUM the amount for account "3183-001-01" and for "Jan to Mar" but how do I do that ? I have tried both "Sumproduct" and "Index" and Match" but I cannot make it sum both...

Dear All, I need help with a VBA code for the following , please - Allocate an amount over time, and split the amount into monthly column, based on a period start and end dates & number of days in each month - e.g Start Date: 01/01/2019 – End Date 31/03/2019, & the spreadsheet has monthly...

I've got a list of Projects with multiple unique month values. What I want to do is take Jan data and compare to the Feb data (same file layout, just different dates) to see if people are changing Feb data after it was entered in Jan. Did they change targets after they were already locked in...

Hey guys - I have an inputbox in my macro that will prompt a user to enter a 3 month character for 1 of 12 months: Jan, Feb, Mar, etc. If the user doesn't type a value or most importantly, incorrectly types the month character like Jam instead of Jan, I want an error handler that will notify...

Hello, I need a bit of help with Offset function. The below is the source data. <tbody> MONTH TYPE CLASS % JAN PA A 90 JAN KR A 100 JAN SE A 80 FEB PA A 70 FEB KR B 80 FEB SE C 65 MAR PA B 90 MAR KR A 80 MAR SE C 70 APR PA A 60 APR KR B 50 </tbody> Below is the OUTPUT...

I have tried to look for this in the existing posts but I'm not really sure what to search for. Due to restrictions as at work I'm looking to solve this with standard Excel formula and not customs or VBA. The data that I have is variable, the number of data in the cell against each month will...

Hello: I have a pivot table with Jan...Dec in A6 to A13 and Sum of Amounts in D6 to D13. I want the add sum of amount for Jan, Feb and Mar in I9. The formula below is returning zero. =SUMPRODUCT(($A$6:$A$13="Jan")*($A$6:$A$13="Feb")*($A$6:$A$13="Mar")*($D$6:$D$13)) Could you help me fix...

Hi all, I need some help regarding Index/Match as I'm not sure why this isn't working. <tbody> A B C 1 Jan Feb Mar 2 30.2 40.2 60.0 3 5.4 15.1 90.1 4 30.1 40.5 50.3 </tbody> in the table above, I want to output which Month has the largest value (so in this case, my output should...

I've tried a selection of formulas, mostly trying VLookups and IF statements to pull the information I need but I don't seem to be getting the result I want. I'm trying do the following: I want to pull the highlighted date in Table 2 (keeping in mind table 2 is on another sheet in my Workbook)...

Hi everyone Hoping someone can help... I have 2 tables on different sheets like so: Sheet 1 <tbody> A B C D E F G 1 Jan Feb Mar Apr May Jun 2 Apples 10% Off 25% Off 20% Off 20% Off 10% Off 20% Off 3 Oranges 20% Off 25% Off 10% Off 20% Off 10% Off 20% Off 4 Bananas 25% Off 20% Off...

Hi all, Small 2 part problem Need to "extract" values which add up to 6 from column B to column C, starting from bottom, which would look like: <tbody> A B C 1 Jan 4 2 2 Feb 1 1 3 Mar 3 3 4 Apr 0 0 </tbody> Note: value in column A might be higher than 6, not less than 0 After that...

I am using this from sample on web to get for Mar, last year Mar amount:- Last year:=CALCULATE( SUM('Transaction'[Quantity]), SAMEPERIODLASTYEAR(Calendar[Date]) ) It works only if the layout of my Pivot has Year and Month on Row Field. However, my report layout is always Year in page...

<tbody> A B C D E F G From To Jan 1 Feb 1 Mar 1 Apr 1 May 1 Feb 1 Mar 15 no yes yes no no Feb 15 Apr 30 no yes yes yes no </tbody> Hello I have a table similar to above. I want to come up with a formula to populate "yes" or "no" from column C3:G4, based on dates entered in column A:B (in...