feb

  1. T

    Pivottable for Yes, No, N/A Responses - Why is it so convoluted?

    I have a table where rows are individual submissions, and columns are questions within those submissions. Submissions contain information such as name, month & location, and questions are answered with either Yes, No or N/A. <tbody> A B C D E F G 1 Name Month...
  2. G

    6 month data on a graph

    Hi! I have a VBA question. I have a bar graph showing the the number of sales every month for the last 5 months. For example: 1000 in Oct, 1200 in Nov, 1300 in Dec, 950 in Jan, and 800 in Feb The Months are in One row (Row A), the number of sales are in another row (Row B). Next month, I...
  3. S

    Max Value with Single Criteria

    Im trying to get the Max value from the longest wait time for the month of Jan, Feb and Mar.i tried using =max(if($c$c="Jan",$h$h)) but it wont work, can someone help me please? thank you so much. SkillGroup Year Month Day Total Inbound Calls Total Calls To Queue Total Calls Abandoned In...
  4. I

    Two complex formulas returning incorrect values

    Hi I'm having trouble returning the correct values in the 2 cells shaded red in the below sheet. My objective is to show the ongoing corresponding number of miles cycled up to the same date in the previous year. The correct value for the current YTD total is the sum of cells C64:C93, which is...
  5. J

    Summing totals from different sheet

    so i currently have two sheets on a spreadsheet. one called active months, the other called payroll. in the active months sheet i have 3 columns. one for each month of a quarter. so for example i currently have in there jan, feb and mar. i then have a list of employers with their start/end...
  6. J

    information provided by dates

    ill try to keep this simple. basically i have a start date and an end date of an employee. the first thing i want to do is work out how many days a person has worked over a quarter. so i need something that will work out how many days there are in jan feb and mar and add these together. then do...
  7. M

    Dates on Horizontal Axis all revert to 1st of the Month

    Hi There, i have searched a few threads but nothing i can use, i am plotting month end dates across the horizontal axis, they are not the last day of the month but the last friday of the month, hence no standard gap from one month to the next. isuspect this is why excel is changing all dates...
  8. J

    VBA solution for selecting a range of months

    The purpose is to select a month from data validation, and other cells populate future months. Then when selecting a different month those same cells change. Is there a way to capture multi months in different cells when a case is selected? Selecting Jan, D2=Feb,D3=Mar,D4=Apr Selecting Feb...
  9. S

    Transposition lookup

    Please help me to bring data from Horizontal array to vertical area. <colgroup><col width="64" style="width: 48pt;" span="8"> <tbody> Horizontal Volume Profit Product Jan Feb Mar Jan Feb Mar A 10 40 70 120...
  10. R

    Taking cells from one workbook based on checkbox criteria of another workbook

    Hello all, I have two worksheets, TW and PP. In TW there is a userform that contains a variety of checkboxes, these determine the information I want to take from PP. There are 12 checkboxes for each month of the year, then four category checkboxes. As an example, if I select CBJAN, CBFEB...
  11. J

    Using a number as a reference to add a column

    HI, I have a list of data as: <colgroup><col width="64" style="width: 48pt;"> <col width="69" style="width: 52pt; mso-width-source: userset; mso-width-alt: 2523;"> <tbody> January 473 February 399 March 706 April 658...
  12. D

    SUMIFS with INDEX MATCH at a loss

    I have a worksheet called "Summary" that should show the total sales by month by category. On a separate worksheet, called "2019", I have a list of sales. I am trying to update the "Summary" worksheet to show the sum of all of sales for each category for each month. The formula I have at this...
  13. K

    Attendance

    https://www.dropbox.com/s/r3p63j9aeshtiq9/test.xlsx?dl=0 Hi, I'm trying the following requirements from the attached excel and not getting. Can anyone please help. 1. Every month should be added 2 in CL column automatically based on date criteria. (I used today() with IF function). 2. If...
  14. D

    find the date of last week's wednesday

    so every wed, I send out an e-mail so I'll be sending out an e-mail Feb 13 (wednesday), but the report is actually spanning from Feb 6 (last week's wed) to Feb 12. note that if last week's wed was a holiday, it would be from Feb 7 (Thur) to Feb 12. I've already made a table to take into...
  15. R

    Excel transpose how to do.

    how can I transpose the info in EXCEL from....to <colgroup><col><col><col><col><col><col span="2"><col><col><col><col><col><col><col></colgroup><tbody> FROM excel in tab 1 code product Jan feb Mar April May June July August Sept Oct Nov Dec 31010054 3 49471 45847 53911 50423 53134...
  16. C

    Need macro to protect columns for the current month and the prior months

    Hello - I am new to writing macros. I know how to write a macro to protect ranges but I need one where I can protect certain columns based on the current month. For example i have an excel file with a column for each month of the year. For Jan I need to protect just the one column for Jan but...
  17. I

    Pivot Chart

    Year Month Salesman Customer Name Category Sales 2018 Target for Jan 2019 2018 Jan Peter A Supermarket Milk 20 22 2018 Jan Peter A Supermarket Cheese 30 33 2018 Jan Peter A Supermarket Juice 15 16.5 2018 Jan Peter B Supermarket Milk 15 16.5 2018 Jan Peter B Supermarket Cheese 17 18.7 2018 Jan...
  18. S

    Finding differences in 2 tables where Id and start date matches but location is different.

    <tbody> Id location start % Id location start % 1234 US Jan 1 100 1234 US Jan 1 100 1234 US Feb 1 100 1234 CA Feb 1 90 9876 CA Jan 1 100 9876 US Jan 1 100 9876 FR Feb 1 100 9876 FR Feb 1 100 7532 US Jan 1 100 7532 FR Jan 1 100...
  19. E

    Power query acumulate sum formula

    Im working in power query, I need to acumulate value per month and account. For january I like to only se value for janauray and then for february summed value for jan and feb and so on. Is there any formula that ca create the coulumn Acum Value below? <tbody> Account Period Value Acum Value...
  20. M

    SumProduct

    How would I use a Sumproduct to calculate V7, W7, X7 &Z7? (For April) I was able to use the Sumproduct for Jan, Feb, March, but am having trouble including April... <tbody> V W X Y Z Jan Feb Mar Q1 Apr 7...

Some videos you may like

This Week's Hot Topics

Top