feb

  1. R

    Copy and paste does not work if I change a single sheet name within the formula

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

    Conditional Formating

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

    Reformat Table

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

    Month/Quarter - If Statement

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

    lookup multiple column

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

    Referencing Value in "Column Groups" (INDEX MATCH..?)

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

    Extract Date from text

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

    sum 2D data in one sheet from another sheet

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

    Need combined average over multiple years using Vlookup or averageif?

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

    VBA extract data based on between dates

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

    Compare Multiple Data Changes with Similar Project Titles

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

    SUM Formula

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

    Hide and unhide columns

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

    Hide and Unhide columns based on multiple criteria

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

    Find WEEKNUM of the MONTH

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

    Pivot Table Help with a Calculated Field...

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

    Pivot Table Help

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

    Offset function

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

    Conditional Formatting Dates

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

    Split data from one cell into several, based on the number of data in the cell...

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

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top