jan

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

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

    match and index not working

    Hi All, I am trying to compare two tables of having varied rows and columns. I want to see if values in table 1 matches with data in table 2. I am using index and match formula. I am checking each cell in table 1 with table 2 data set. However I am getting 'no match' everytime. Can anyone...
  5. 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...
  6. J

    Change Calender starting month from January to April

    Hi Guys, The sheet shown below tracks spend by calendar years and we need to change it to spend by tax/fiscal years April to March. Does anyone know how to do this ? Thanks <tbody> Supplier 1 MONTH Apr-17 £59.00 May-17 £60.00...
  7. 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...
  8. P

    Copying worksheet (containing formulae & data) to another workbook, to use for the next yr

    Hi Using Excel 2010 on Windows 10 I have a Workbook for 2018, Sheets are Jan - Dec, ie 12 sheets, plus a sheet containing data, ie named payees (income) and recipients (outgoings), that has been 'entered' from the previous month, plus manually entered too. There is a 'Master' sheet which...
  9. E

    Calculated subtotals in Pivot table

    I want to add calculated subtotals into a pivot table Like in a finicial report you want to se Margins after different categories I have the scenario in the tabels below. My datatable is added to the datamodel with connection only. A table with balance per account, I have created an "Income...
  10. E

    Calculated subtotals in Pivot table

    I want to add calculated subtotals into a pivot table Like in a finicial report you want to se Margins after different categories I have the scenario in the tabels below. A table with balance per account, I have created an "Income statement report" in a pivot now I would like to add the 2...
  11. 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...
  12. 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...
  13. D

    Change Sheet name in the formula

    This formula for find duplicate in multiple sheets but i have a problem when changed the name of sheets =$A$2:$A$1000000 =SUM(COUNTIF(INDIRECT("'Sheet" & ROW($1:$4) & "'!$A:$A"),$A2))>1 That rule i apply on the Home ---> Conditional Formatting ---> New Rule The problem is when i change sheets...
  14. S

    Vlookup, Match, Index, Nesting If's....

    I've been trying to figure out the best way to get data based on a current date and typically use vlookup but it won't allow 12 conditional statements to look at each month. I want to populate based on the current date retrieving from tables from each month assuming the table was extended out...
  15. J

    Repeat a number X amount of times

    Okay so I have two tables: Count Jan Feb Mar April May June July 0 0 1 0 0 0 0 Revenue Jan Feb Mar April May June July 0 0 25 25 25 25 0 How do I make it so it repeats the 25 X amount of times starting from the count? Currently X=4 but this may change.
  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. M

    VBA code

    Hi, i need help friends for writing VBA code for copying data . For example i have data in A and B columns. when I click on button Data must get Copy as Jan ABC,JAN DEF continue till B end, then a2 b1,a2 b2 etc. <colgroup><col width="64" style="width:48pt" span="2"> </colgroup><tbody> A...
  18. M

    Fill in blank cells with adjacent cell value

    Hi Everyone, I am pretty new to Excel and VB (got some basics :) ). I was wondering if someone can help. So I have a column G containing cells of different values(times); some of those cells are blank. I also have an adjacent column F that doesn't have any blank values (all filled with time...
  19. J

    Best way to pull multiple SQL data queries into Excel

    Hi there everyone I have a spreadsheet that has each month of the year as a column and each of our products as a row. I need to use SQL data queries to pull through the total amount of sales per product each month. I have the SQL script for each month/product, but I'm unsure of the best way to...
  20. S

    Help with Nested IF

    I have someone that doesn't need to make a payment until after they reach $15,000 year to date. However, if they reach it within a month, I need to only charge them the difference, and then every month after needs to be what they actually owe. I am trying to figure out the formula where these...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top