feb

  1. S

    Count items from table, with multiple criteria and on unique items

    Hello, Currently I am having a problem with a count issue. From a table I need to count a number of items based on several conditions, so I used the countifs formula. I have for example 2 criteria already set in the countifs formula. see below for example: <tbody> Criteria A Criteria B...
  2. E

    Macro to build a database

    Hi guys, Can someone please can help me with this problem? I know it's a macro but I don't know how to start: I have a folder called Data in this extension C:\Documents There are 12 sub-folder (Jan, Feb, Mar,.., Dec) in the folder Data. Every sub-folder (Jan, Feb, Mar,.., Dec) has 30 files...
  3. W

    VBA for printing weekdays in every page

    Hi Everyone , if I want to print all the weekdays in between a range , i.e 3 Feb 2017 & 23 Feb 2017, one single weekdays per every page,for example the first page will be 3 Feb 2017, second page will be 5 Feb 2017 and till 23 Feb 2017, is there any easy way to do that ? Thanks
  4. JenniferMurphy

    Proper syntax for summing over intersection of named ranges

    In the table below, the following named ranges are defined: <tbody> $A:$A TableLeft $E:$E TableRight $1:$1 Jan $2:$2 Feb $3:$3 Mar </tbody> I need a formula in E1 that will be the equivalent of =sum(B1:D1) but using the named ranges. <tbody> R/C A B C D E 1 Jan 3 7 4 14 2 Feb 6...
  5. E

    Sorting Data In A Pivot By Month to create trendline

    Hi There, I created a Pivot Table that lists out client information and the months they had software licenses. I have the data below, but would like to sort by month so it sorts by all clients with licenses in Jan, then Feb, then Mar, etc. So what should happen is when this report is finalized...
  6. J

    Address Function to increase reference cell by 1

    Hi, I'm working on a project and I need some help with the address function. A few notes for reference. Sheet I'm working in is called 'AvB' The sheet I'm drawing data from is in the same workbook and is called 1) 'BS' Background: The sheet called BS stands for balance sheet. On that sheet...
  7. E

    SUMIF with an INDEX MATCH for Year to Date Dynamic Formula

    This is probably very basic but I'm struggling with it. I have monthly financials from 2016 to 2017. January 2016:December 2017. I would like to be able to pull YTD figures based on Month and Year. A1: Month: Feb A2: Year: 2017 In A3 I would have Sum of YTD Feb 2017. If I change A2 to...
  8. T

    Convert Horizontal Data to Vertical

    Hello, I have a long string of data that is laid out horizontally and I am trying to find a way (without VBA) to relatively easily convert it to be vertically stacked. Below is a small example of what I need to be able to do on a much larger scale. If I set up the horizontal spreadsheet to...
  9. T

    Sumifs, vertical and horizontal

    <tbody> KKS Application Actual Before 6 Feb 2017 0 0EGA Rings 0 0EGA Lagging 1st Layer 0 0EGA Lagging 2nd Layer </tbody> <tbody> Before 6 Feb 2017 Before 6 Feb 2017 Before 6 Feb 2017 KKS Code Rings Lagging 1st Layer Lagging 2nd Layer 0 0EGA 2 0 0EGA 5 9 3 0 0EGA 6...
  10. S

    VBA Transpose rows to columns

    Hi All, I've been searching the forum, but haven't been able to find exactly what I need. I need a macro that gives below result, hope anyone can help. Data: <tbody> Jan Feb Mar P1 Q1 75 100 125 P2 Q2 30 40 50 P3 Q2 10 40 70 </tbody> Result: <tbody> P1 Q1 Jan 75 P1 Q1 Feb 100...
  11. N

    Rolling 18 months pivot chart, with year over year

    I'm wanting to create a year over year pivot chart. The issue I'm having, is that my two periods are 18 months long. Feb of 2016 to July of 2017 vs. Feb of 2015 to July of 2016. So in each period of time (I've added a column that is 15-16 and 16-17) the months that are displayed twice in the...
  12. srizki

    Change text to date format.

    Is it possible to change text like, <tbody> Apr 2017 FEB 2017 Feb 2017 To real dates? </tbody><colgroup><col></colgroup>

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