period

Please help me to compare Data same location & same period last year.

Hi All - I have a working query that allows me to filter out customers who have less than $60,000 in sales. However, I needed to add a Period field to the Query to see sales in each of the last four years. The only thing now is that using a simple filter in my query after adding the Period...

I have a table with column a:a dates Column b with status codes e.g W I want to produce a report on the total number of say “W” in a set period So for example 1/1/18 until 30/1/18. Equals 4 1/2/18 until 28/2/18. Equals 1 And so on. The formula on a different sheet looking at tab “2018-2019”

Excel 2007 Sample sheet: Col A Date (dd-mm-yyyy) Col B Withdrawal (Amount - numerical) Col C Deposit (Amount - numerical) A3 02-07-2018 A4 02-07-2018 A5 04-07-2018 A6 04-07-2018 A7 06-07-2018 A8 09-07-2018 B3 11000 B4 15000 B5 0 B6 17000 B7 5000 B8 12000 C3 20000 C4 30000 C5...

Hi Any help please I am trying to record values every set time period eg 5 minutes, from COLUMN G and every second cell. Cells G9, G11, G13 etc to AG9,AG11,AG13 etc. For example if it is 10.00am and value in G9 is 10 I want that value stored in AG9. Then at 10.05 if value in G9 is 11, I want...

Hi everyone,I am trying to create a spread sheet that adds up my staff's hours worked for a rolling 119 day period, sounds easy but I have to ignore any day that they have taken as leave but still include a 119 day period. For example if I had a member of staff who took 6 days off in that 119...

I would like to a a period to abbreviations for Road(Rd.), Street(St.), Highway(Hwy.), Lane(Ln.) etc. in the address column in excel. Address column is Column F Row 2. Let me know if you need any other information. Thank you!

Dear all, I have two pivot tables on one worksheet, one for the input and one for the output of material. Both are based on different tables and have two filters for year and period of the year. On another sheet I can select a year and a period, hit a button and the filter of both pivot tables...

Hi, I need a formula that will sum a range based on three criteria: 1) Project Code (D7:D17) 2) Region (C7:C17) 3) Period (E5:P5) I tried a Sumproduct but it freaked out with three criteria :/ - I need this to obviously look at all three corresponding columns (dependent on whether it's Q1...

Hi All, Sheet1 <tbody> Start End Billing Period 01/01/1900 15/05/2017 1 16/05/2017 15/06/2017 2 16/06/2017 14/07/2017 3 15/07/2017 15/08/2017 4 16/08/2017 15/09/2017 5 </tbody> Sheet2 <tbody> Event Details Start Date End Date Number of Nights Billing Period(s) Event A...

I have data that shows the all the store visits made by each person with their timestamps and looks like this: I need a formula that will work out the following in two separate columns: - A visitor who has made at least 1 visit in a 6 month period - A visitor who has made 6 or more visits...

Hey all, I am having trouble to come up with a formula to auto-populate the split amount based on the starting period (Column A) and ending period (Column B) I have been able to split the amount with formula, however, I would like to Transfer them to the respective periods in column H -...

At my wits' end - help gratefully received! I have a spreadsheet of animal behaviours where each row represents a time period. Each cell contains a letter code for behaviours they performed in that period. There can be more than one behaviour in a single cell. So this would be an example of my...

I have a spreadsheet for new hires where I have a column for their start date and one for probation period end date. I have it set up so that the probation period end date automatically calculates 3 mos from start date. I would like to have the probation dates highlight when the date is 7...

Hi, i have an excel file (attached). It has a list of names and then periods (1-10). Each name has listed 2 activities they'd like to participate in. I'd like each person to get their first choice 60% of the 10 periods and second choice 40%. I also need to make sure that each period and activity...

This is weird: I have 4 command buttons (CommandButton1 thru CommandButton4) and 1 text box (TextBox1). I get a 424 Error whenever I try to set a TextBox1 property such as TextBox1.Left I ran a short sub to grab all the shape names in the active worksheet: For Each Sh In ActiveSheet.Shapes...

Hello everyone, I am coming across with coming up a formula to summarize the description. basically I would like to find the Serial number in column A. If it is other or reserve, then no further steps to be taken, other than that, I would like to find the respective payment type, period...

hi, I attached the spreadsheet I am looking at as an example for the code. although I have the logic, i am having trouble writing a code to do the following in sheet 1: searching through column A, find a cell that has a period in it starting from A3 (so the first one the macro should find it...

Hi, I have got a data set with multiple sheets, each represents an identical course number. I am wondering if there is a way that I could select from the drop down list in the "master" sheet and have the sheet pop up by the selection value. here is a link to my sheet...

I have three worksheets with financial reports from varying periods. Accounts (column B) are added and removed all the time meaning that rows do not perfectly match up. Account#123 may only be on sheet 2, while Account#456 may be on all 3 sheets. I need to compare account balance changes by...