period

Good Day, I have a large spreadsheet with more than 76,000 rows. In this spreadsheet I have 3 columns, namely Date, Time and kWh. The kWh column gives half hourly electricity consumption values based on the Date and Time interval. I need to roll up the date and time columns into a 24 hour...

Hi all! Really new to excel projects and upon doing some research on my own i find myself stuck.. I am currently working on making a time card to be submitted via excel. Currently the user will select the appropriate pay period from a drop down menu in a cell. Let’s say A1. The pay period they...

I have a table, Column A represents a billing period (11/30/18, 12/31/18, 1/31/19 etc.) and column B represents an amount received for the applicable billing period ($100, 115, 105, etc.). In a separate cell I want to return a date of the last invoice payment received. So, if the table above...

This should be simple but I can't get the right syntax. I need to figure out the last row in column B and parse a string value from the text in that cell. I created a named range (dcLastRow) to return the last row (132 in current report) and want to use that named range within my cell formula...

I'd like to create a workload tracking tool for a job that has predictable tasks, but is unpredictable regarding the timing of task entry into the workload queue. Tasks arrive at unpredictable times/dates, and have a set number of days between arrival and due date for completion. I would like...

I am struggling with a Power Query performance problem and have exhausted all of my ideas, so I am hoping someone here may have an idea. I have two tables: - Fact table containing sales data: approximately 200,000 rows. The relevant fields for this question include Item Number and Period...

Hello, I would be grateful for some assistance, please. My company uses 13 'periods' of 4 weeks each for it's reporting. How on earth can I get excel to be able to produce reports using "normal" dates from the data source, but then somehow referencing them against the year/period/week? I...

Greetings, I would like to separate values held in a cell. The cell content is produced from a web query and is of the format below: "11.00+1.00 (+10.00%)" I would like to use the leftmost '.' (period) as a reference point if necessary. I would like to set as a variable value any numbers to...

Hello All, There is a set of data in sheet 1. <tbody> Category Unit Period Data Lifecycle </tbody> There are 5 different units, and the categories can be similar or different across data. The data needs to categorized across units, per category, per period based on the lifecycle (only...

Hello All, There is a set of data in sheet 1. <tbody> Category Unit Period Data Lifecycle </tbody> There are 5 different units, and the categories can be similar or different across data. The data needs to categorized across units, per category, per period based on the lifecycle (only...

Hi, I am looking for some help in finding an excel formula which will look up to manual values against a table on another sheet and give me the number in return. For example, On sheet 1 I am looking search for the following values, Colleague name and period. Within the table on Sheet 2 i...

I have a report that is published monthly and I use the data from this report to generate a sub-report. The data set below is a compilation of 4 months of reports and has overall filter, which I apply when I pull the data together. This is also a truncated and slightly masked data set, but the...

I am trying to force the input of data into 2 different textboxes so that the user can't input an incorrect value or in the wrong format. The textboxes are on a userform and I need them to format as the user types so they are formatted as follows; In both examples, they should only be able...

Hi all, Hope everyone's enjoying their Holidays. Please help. I inherited a spreadsheet with formulas that refer to a separate range. With each new month, the entire range needs to move over one column to consider only the latest (12 mo) periods. Is there a quick and easy way to change the...

I have data of few months. <colgroup><col><col span="2"></colgroup><tbody> Date Name Value 01-04-2018 a 2 03-04-2018 b 2 05-04-2018 c 8 07-04-2018 d 3 09-04-2018 e 1 11-04-2018 f 3 13-04-2018 g 10 15-04-2018 h 9 17-04-2018 i 5 19-04-2018 j 7 21-04-2018 k 4 23-04-2018 l 5...

Is there a formula that creates a text string as shown below from the following inputs: Period Start 4 Period End 6 Factor 0.5 Text string 4|0.5;5|0.5;6|0.5 The text string is in a format that a software program requires for an upload file. Any help appreciated. Thanks

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #003ecc}</style>I have a worksheet of all of my students in A:H. In column D I have the class period for each student. I'd like to dynamically filter each class period to its own separate...

Hi, I have a simple question . I have an list what i want to show in circles. Each circel is an % of the total. Who can help me? value's will change next period. 1. 11.65 2. 42.05 3. 5.00 4. 1.90 5. 3.85 6. 7.58 7. 12.80 8. 8.30 Total 93.13

Hello friends, I would like create a max and min formula that would also meet some criteria. Column A is for Date Column E is for Price Cell N5 is period start date Cell N6 is period end date I would like to know max and min price within the period. The formula which i used was...

I have a module that contains several subs. Each of the subs contain the variable below where the "period" is updated by 1 each month. So next month the 1019 would become 1119, then 1219.... Since each sub contains this variable you must update the "period" in every sub. Is there a way to...