feb

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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