feb

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...

Hello everyone, Please see the data; <tbody> Installment Due Date Installment Receipt Date 31-01-2019 28-01-2019 28-02-2019 30-03-2019 30-04-2018 </tbody> the first column is Installment date while the second is the actual received date. As i have a large data i want some formula...

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 Can I do multiple column Vlookup. I searched the internet but most of examples are using Match-Index. I want to learn multiple Vlookup first then I will go to match-index. I am thinking of array function but do not know how to start I have the table below. I want to do the following Enter...

<tbody> Jan Jan Jan Feb Feb Feb Mar Mar Mar Subscribers Leads Customers Subscribers Leads Customers Subscribers Leads Customers Homer 5 6 7 6 7 8 7 8 9 Lenny 6 7 8 7 8 9 8 9 10 Carl 7 8 9 8 9 10 9 10 11 Barney 3 2 1 4 3 2 2 1 0...

Hi all, I have the following TEXT(not date format): Stocks - Market value = $1,00.00* Tue Jan 30 2018 4:49:33 pm EDT in Cell A1 sheet 1 I wish to extract the date only to be 1/30/2018 in sheet 2 in cell B3 Note: the dates change like Feb 21 2017, Apr 4 2016 etc. I tried the MID function...

<tbody> Account CC Acc-CC Descr Jan Feb Mar Apr 301000 000 301000 000 Alt Rev 0 0 0 0 301000 100 301000 100 Alt Rev 500 500 200 400 301001 000 301001 000 Revenue 5000 8000 10000 6000 301001 100 301001 100 Revenue 0 2000 5000 8000 301001 200...

My Data basically looks like the table below... I'm trying to figure out a formula that will look up the letter in Sheet 2 find the corresponding letter in Sheet 1 and then determine the average of the 2017 and 2018 corresponding month. For example For the letter A the formula should return...

hi, i would like to extract some data based on the date (Between dates) using userform (date start and date end) example data below SHEET1 <tbody> A B C D E DATE REF CODE AMT NAME 1 JAN 2, 2018 AAA 111 25.25 STEVE 2 JAN 7, 2018 ABC 123 654.00 JOHN 3 FEB 6, 2018 DFS 364 215.40 MICHAEL...

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...

This is probably a REALLY basic thing but I couldn't find anywhere with a solution which works... Is it possible to SUM all of the numbers in Column C Where Column B (On the same line) equals X. (Example Below) <tbody> Month Total Jan 2018 5 Jan 2018 4 Feb 2018 7 Feb 2018 4 Feb 2018...

Hello, I am using CheckBoxs to hide and unhide columns i will have several CheckBoxs for different years, and the same several CheckBoxs for Months. what I want is that if my user chose say 2016 then he will have all 2016's month visible, but then if he wants to say only specific months he can...

Hi Guys, I have similar question and I was hoping someone can help me with it as I am trying to develop my VBA capabilities. I have an excel file that will hide and unhide based on multiple values which mainly year and month criteria, meaning: if it is 2016 chosen then all the columns of 2016...

Hello Ladies & Gentlemen, I'm unable to get my head around this WEEKNUM Solution which you had provided on Excel Campus by Jon Acompora. <tbody> http://www.excelcampus.com/pivot-tables/month-to-date-mtd-comparisons-pivot-table </tbody> So I shall be breaking it down so that you can point out...

Thought I'd repost this as the formatting did not come through correctly in the original post...apologies. One thing I did try was to use MAX and MIN on the date fields to determine number of shifts being looked at and therefore get an accurate value: =DAYS360(MIN(C3:C17),MAX(C3:C17)) It...

I have a spreadsheet that calculates the time a surgical case takes on a particular shift (Thanks shg!). I am attempting to create a Pivot table that could analyze how much of the available room time is taken in a particular room or group of rooms during a given time period I inserted a...

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 a list of dates from 01Jan14 thru current. They are already in order, but I would like a way to fill the cells to visually break out the different months. For example, Jan,Mar,May.. blue and Feb,Apr,Jun.. gray. Is there an easier way to do it than make separate conditional formatting for...

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...