oct

  1. willow1985

    Average of an Average

    I suppose this is more of a math question but I also want to know if I am calculating this right in excel / would be getting the correct numbers. I want to get the average turn around time (time between 2 dates) for the last 30 days. My data is as follows: <tbody> Date 1 Date 2 Difference...
  2. K

    Is there a way to automatically duplicate a system subfolder structure in Excel?

    I've been asked to create a tracking template to track every step of the process for formal inquiries that go into a Outlook inbox. The plan right now is to create a system folder for all inquiries, and then in that folder create a subfolder for each day an inquiry comes in, and from who...
  3. B

    Changing the month in a sheet name

    I have several files that I use every month. I have two sheets which include the current month that I am working on. For example, I'm starting the November file and I need to rename a couple of these sheets from Sept to Oct (I do commissions so we I am preparing the Oct commissions to be paid...
  4. C

    Dynamic Graphs, as columns are added daily

    Hello, I have searched online and in the forum for this answer. Everything I find only references is you have a table, or data within two columns, and you are adding additional rows of data. My scenario is that I have my dates as my headers/labels, and my data name/header is in column A. As...
  5. G

    Index, Match when values the same

    I'm trying to setup a roster. In Cell K1 I have the date (which changes through drop down box). In column A I have a list of dates which some are the same date, Column C has Team 1 and Column E has Team 2 What I'm needing is when I change the date in Cell K1 it only shows Team A on that date in...
  6. B

    using dates with index matches

    <tbody> 2018-08 1 Aug 18 31 Aug 18 2018-09 1 Sep 18 30 Sep 18 2018-10 1 Oct 18 31 Oct 18 </tbody> Please see table above. If I have a date like 9/15/18, I want it to run a search against this table, then return the corresponding result in col A, ie 2018-09. At the...
  7. F

    Formula Help Needed please

    Hi, I need some help with a formula. I have a table with values per month and an in stock quantity. Has anyone any idea if you can use a formula to give you the month in which the stock will run out? I.e. ROW 1, the stock will run out in "Oct 19" - is there any calculation that will provide...
  8. M

    Count non blanks 5 years from the last non blank date

    I have a sheet with the column headers as dates by month and year. Column A is "Jan 2002", Column B is "Feb 2002" etc until Column HC "May 2019". In Column HG I have a the date of the last time my customer ordered "Aug 2007" for example. For each month there is either a dollar amount or it is...
  9. B

    how to calculate the number of months between two dates?

    I have a number of dates in a column. In each case I'd like to see how many months between the dates in that column, and another date, say Oct 31. I don't care about the number of days, just number of months. So if I see a date like May 1, I'd like to see the difference between that and Oct 31...
  10. A

    For each chance in column A, copy column B and fill down in column C

    Hi All, I'm looking for a for a macro or formula that recognises a change in Column A, then at each change, it copies the same row from column B, pastes the value to column C and fills the next months downs until the next change in column A. At the moment I have Column A and B however I want it...
  11. Q

    if formula to differentiate between months

    Hello, I need some help with my data with different months across a financial year. I want to pull out ending month data, so where the date changes from one month to another eg. Sept - Oct - different month so pick the ending value shown in the column, else 0. The idea is that I want the...
  12. H

    Unhide Columns Containing Month and year

    I have several sheets containing the Month and Year in B4:M4 (Sheet3 to Sheets11) I have set up months and year on sheet "Months" and linked this to Cell A2 using data validation I have written code so that if for eg Oct 2018 is selected from the drop down list, that the column containing...
  13. I

    Creating dynamic chart showing last 90 calendar days entries

    Hello I have literally rubbed my eyebrows away trying desperately to create a dynamic line chart with columns A, G and H from the below data, so the chart shows only the most recent 90 calendar days entries (NOT the last 90 entries - please let me know if it's necessary to insert a daily entry...
  14. A

    Excel won't recognise as date ( mm/dd/yyyy)

    Dear All, The attached excel sheet have date value in different cells , But excel won't recognise as date , So i want all cells date value recognise as a date value in (mm/dd/yyyy) format. While applying formula on cell values it won't recognise as a date value. Oct 1,2018, 2:05 PM Oct 1...
  15. I

    How to calculate number of non-rest days YTD current year and last year?

    I have kept a personal exercise log for many years and I am trying to keep myself motivated (extract below). Column A12 contains consecutive dates exercised from 01.01.1999, and a row is added to this for every new day. Column B12 contains exercise activity. Mon, 8 Oct 2018 OTHER Tue, 9 Oct...
  16. R

    Dynamic Table based off User / Shared Workbook

    Good day! I am creating a Shared Workbook and need to create a dynamic table based off of the CurUser (defined name). Want to know if this is possible. Table1 (Dynamic) <TBODY> ID # Correspondence Name Submitted By Submitted On Due Date Last Action Taken (LAT) LAT By...
  17. M

    Help with something more advanced than VLOOKUP

    I would like to create a worksheet that includes pulls data for each fund, but one fund (i.e. AA Fund) at a time and for Net Purchases for fund total ($6,678.00 as of Oct 1, 2018). I would like to create a table that shows the time series. For example, column A should be the date, 10/01/2018...
  18. D

    Lookup to compile information

    Hi Everyone, I am hoping someone can help me out on this one. I have a table similar to below, only larger. Headers are dates usually 6 months or so, but each column is a week. The rows are items. This table is on one worksheet. On a separate sheet I want to have a dynamic monthly total sheet...
  19. J

    If Date is on or after Oct 1, but before Jan 1

    Not sure how to construct a formula to check for between date ranges for any year, not just this year. I need to return a specific value if today's date is on or after Oct 1, but before Jan 1, and a separate value if not. Any help is appreciated.
  20. T

    Format multiple Excel sheet names

    Hello! I've been trying to figure out how to rename multiple sheet names for all of today.... I've never done Macros or anything like that before and I've been trying to but nothing is working the way I want to. I'm in charge of creating schedules for work and each day is a different sheet and...

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