jan

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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