weekly

Hello, all! I've been searching all over the web to find an answer to this, but I can't seem to find anything. I hope I'm able to explain properly what I'm encountering: I created a budgeting tool for my coworker. It consists of four sections: AR, POs, Overhead, and AP. There are 10 columns of...

Hello I need help setting up a weekly report table or pivot that shows the number of open, resolved, pending, and new added tickets. The new data for the report comes out every Monday morning and I will send my report every Monday afternoon showing the number of open, resolved, pending, and new...

I have a situation where i have 12 months in a row acroos my worksheet.( Jan-Dec), and i have 6 catgories with total number of students that attend across the top. each month has 4 dates. so what you have is each month they meet weekly and i have a attendance number. I another place on the...

i have a series of clients that need work doing. each one has house work on at a different frequency. some weekly, some 2 weekly, some 6 weekly etc. in additional these clients have garden work on at a different frequency I would like to be able to add these clients to a database, say the work...

Need help taking the last data point (DCP) off several dynamic linear charts. The last data point is the weekly average and it often creates a blip at the end of the data. No VBA please. Thank you so much...

I'm trying to merge data from a weekly report into a master sheet that runs calculations. The weekly report is always formatted the same, and the calculation sheet will be as well. What's the easiest way to import data from the report to the master? I.E. F33 on the report will always need to...

Hi, I have a Weekly Schedule sheet that I would to populate with formulas from the Appointments sheet. Does anyone know how to do this? Thank you Excel WorkbookAIKLMNOPQR1INDEX8:00 AMLunch Start12:00 PMMax working hours per day92Lunch End1:00 PM3Lunch Time1:004INVJOB TIMESTART DATEDAYSTART...

I am getting the #NAME? error on this formula: {=INDEX(O6:O130,MODE(IF(O6:O130<>"",MATCH(O6:O130,O6:O130,0))))} I am using the SAME formula in another data set on daily market prices (the above is for weekly) . . . and I am NOT getting an error on that sheet (??) That error says I have...

Hi All, I have a two sheets a master sheet and a weekly report sheet. I need to firstly recreate the previous weeks weekly report sheet based on the cell value i put on the master sheet For example Column A ( Master Sheet ) is the week numbers A2=WK27,A3=WK28 Etc when i add WK29 into cell...

Hello, I've spent quite a while trying to work out how to use sum product with a look up nested inside it. I'm trying to calculate the annual sum of payments received by a group. People in the group receive payments either weekly or monthly. I receive a regular report which contains: how...

I am trying to create a fiscal week lookup table for a spreadsheet I am working on. My boss needs TY/LY weekly comparison. I have tried to use the =weeknum(b1) command. However, our first fiscal week is 2/3/19-2/9/19, so the value returned using that formula is 6. I am able to get it to read 1...

I am making a weekly summary file for my bar. End of each week I "move or copy" the 7 daily cash up sheets into the weekly sheet, named by the days of the week. In the weekly sheet, I have the cash summary page, which has a column of various headers (denomination, pdq, amex, discrepancies, etc)...

Dear Excel community To start with, I am an Excel novice - please forgive me any naive questions. Context Column A contains dates in ascending order - each row for a new day. Cell C1 contains a variable as text string, which can either be "weekly", "fortnightly", or "monthly". Problem...

Hello Spreadsheet 1 Name : Weekly Results (tab 1 named : 01/04/2019; tab 2 named : 08/04/2019 etc....) Spreadsheet 2 Name : Weekly Report (tab name is "Weekly Report") Spreadsheet 2 tab with Date : Reporting Period ( tab name "Report Period" with Date entered in cell A1) I have a spreadsheet...

Hello Everyone, I am new to Excel and need some help for my project. I want to extract a particular cell value on weekly basis. The start and end date of project is known. The cell value named 'percentage of work completed' updates every day, but I want to know the status only on weekly basis...

Hello, I have a large spread sheet that lists multiple currencyvalues. For each value there is anassociated daily fee, weekly fee, and monthly fee. For example: <tbody> Value Daily Rate Weekly Rate Monthly Rate Value Daily Rate Weekly Rate Monthly Rate Value Daily Rate...

Hello, I have a large spread sheet that lists multiplevalues. For each value there is anassociated daily fee, weekly fee, and monthly fee. For example: In a separate location I want to be able to populate the dailyfee, weekly fee, and monthly fee for the specific value that I enter into...

Hello, I am trying to pull certain data from a raw data file that is updated weekly from another source and place it in a more presentable model. I am having to use multiple criteria (Columns A and B below) to try and get the appropriate lookup value from Column C through F but am not having...

Hello there !!!! I am new to excel and trying to do a pretty big project and I cannot figure out how to solve an error that keeps popping up. I have a weekly schedule which has 7 columns, each one for a day of the week. I am now trying to do a daily schedule which copies all the values from the...

Hi All, Brand new here and hoping you can help ;o) I have a simple weekly budgets spreadsheet that also tracks the actual sales values. What's the best way to recalculate the remaining budgets as the actuals come in? Basically, if the cummulative weekly actuals vs budgets are negative, take...