Forum Widgets
Latest Discussions
Calculate Monthly Sales Target Excel
Hi I want to calculate individual monthly sales targets per advisor in my team based on an overall monthly target for the team. So I have a monthly target of £28,487 with 11 people in the team, the issue is some only work part time so their target needs to be less than those working full time. How is best to work this out on excel? Below is the example of the sheet I have, I've removed staff names but the working hours are real hours for my team, the £28,487.00 needs to be split equally across the team with those working less per week to have a fair share. The daily target should say Monthly Target sorry.VLOOKUP FORMULA FOR ATTENDANCE TRACKER
I have the following attendance tracker, on the Register tab I want the shift times to be automatically populated based on the date and pulling the data from the Employee tab (sheet) I have tried to have a go with a VLOOKUP formula but can't seem to work it out. Can it be done based on the current set up? Thanks Any help would be much appreciated. https://docs.google.com/spreadsheets/d/1Imot_A0wfcQYbAGu-0ZQXH1P_Ufhskvfd8LVii5veTs/edit?usp=sharing Various VLOOKUP formulas found on google but i'm a novice when it comes to formulas to be honest Images:
Rolling 12-Month Average
I want to have a column showing a rolling 12-month average for each individual contributor. The table is laid out like this (showing a full 12 months with the previous months' columns hidden): Name | Rolling Average | Jan 25 | Dec 24 | Nov 24 | Oct 24 | Each month, a new month column gets added to the left and the oldest column on the right gets hidden to keep the sheet cleaner. Any help is appreciated! Shannon
Conditional Formatting on Data Range
Hi I am trying to set some conditional formatting on a row of data. The row contains numbers from 1 - 52 with the cells changing based on project dates (so the number won't always be the same in the cell if the template is used for different projects). Any cell that contains a number including 4, 8, 17, 21, 30, 34, 43, 47 I want to fill the cell in one colour. Any cell that contains a number including 13, 26, 39, 52 I want to fill in a different colour. Can anyone help me with the formula I need to conditionally format this row such that the cells format automatically please ? ThanksPercentages in Pivot Table
Hi, Here is a sample pivot table in which I am trying to determine the percentage of notes doctors are blocking. How do I get the third column (H) to show the percentage of blocked notes? Obviously if this wasn't a pivot table I would simply divide column G by column F, but how do I get the pivot table to do that? I've played with all of the calculation options in the Field Values Settings, and I can't seem to figure it out. Thanks for your help.
Fill a table cell with data from another table based on the adjacent table cell value
Hi Community members, I am compiling a spreadsheet to list the department meeting schedule for the year, retain records of past meetings, and record statistics for meeting presenters. Sheet "DC-80 Outlines" contains a table listing talk outlines prepared by my company's WHS department. Several other sheets will reference this sheet. In the sheet "Schedule Archive", I used a named range for the data validation list in column C. That named range is column A in the "DC-80 Outlines" sheet. I want to insert a formula in column B that fills the talk outline title from the "DC-80 Outlines" sheet based on the value selected from the data validation list in column C. I tried several formulas but I could not deliver the result required. Many times the formulas displayed the "#SPILL" error. Below is a link to the spreadsheet. https://docs.google.com/spreadsheets/d/1DEt4jeG8RioHasQ1NCiqkzhI2VLHdDXQ/edit?usp=sharing&ouid=111989026891693955929&rtpof=true&sd=true Any suggestions for a formula or adjustments to the spreadsheet? Many thanks, TimExecution of Macro-Enabled Excel File on NAS Server
I want to share and use an Excel file with macros stored on a NAS server. The file is located on the NAS server, but due to security reasons, the macros are being blocked. This file is meant to be shared and used directly from the server. Could you please help me find a way to run the file from the server without the macros being blocked?
