Forum Widgets
Latest Discussions
Sum from cell across multiple sheet, depending on hire date
I can not figure this out, I am trying to make a summary sheet that will count the vacation days across multiple sheets from "Start" to "All" (these are timesheets between those named sheets) for employees. But I need the count to reset on their hire anniversary month and day. Employee 1 - Hired on 1/2/2001 (found in cell B5 on the sheet named "Summary") Employee 2 - Hired on 4/9/2020 (found in cell B6 on sheet named "Summary") In this example, any vacation days in cell F5 (employee 1) across multiple sheets between sheets named "Start" to "All" will count until the anniversary month and day arrives, then it will reset and start counting forward again until that date arrives again. Any help will be much appreciated!
Lookup seat number on table plan
Hello all, hope you can help me. In Excel, I've a table plan where I've assigned names to numbered seats. I now want to read the 'read' that table plan and create a list that tells me the name and seat number. I already have the list of names (in Column L), but need a formula for Column M to do the lookup of the seat number on the table plan. The seat number is always located in the cell above the name. For cell M2, the formula should return that Arthur is in seat C7, and in M3, that Ben is in seat B3, and so on. I suspect the formula could be a combination of one of the Lookup variations, INDEX or MATCH, or even using the CELL command, but I've not fathomed it yet. Does anyone have any suggestions on how I could do it? Many thanks
Stop Microsoft's nagware pop ups
Once more, I'm on a new computer which has reset all of Microsoft's nagware pop ups that remind me how to use a product I've used for literal decades. "Did you know you can click here and do this". "I see you went to a new menu, did you know you could see ____ in this menu but you can't actually see it because this intrusive pop up is blocking it?" "Here is another pop up that deselected the cell you were currently typing in and you didn't notice is for 5 minutes so you have to redo everything you just worked on. Sucks to be you." How the hell do I get this nagware garbage to go away forever and never, ever, ever, ever, ever, ever come back?!
Add Letter Into Number
I am wanting to see if there is a way to have a letter inserted into a cell that already has a number if another cell meets a certain criteria. See below for example. Cells in Column D are prefilled with a number. Once the adjacent cell in column L is filled, I would want it to put a letter in Column D after the 25 as you see. Anyone know if this is possible? If so what would the formula be? I have racked my brain trying to create it but I'm coming up empty.
Conditional Formatting for multiple range
I wonder can we make conditional formatting in excel to hightlight certain values in multiple ranges in a couple of certain columns? A B C D E F G 1 value Percentages of Total value Percentages of Total value Percentages of Total 109 61 122 61 145 61 50 28 54 27 67 28 19 10 21 10 25 10 178 100 197 100 237 100 2 Values Percentage of Total Values Percentage of Total Values Percentage of Total 1 0 1 0 2 1 0 0 0 0 1 0 1 0 1 0 2 1 4 3 4 2 6 3 11 8 14 9 15 8 17 13 18 12 23 13 17 13 21 14 27 15 20 15 22 15 27 15 31 23 32 22 36 20 28 21 31 21 34 19 130 100 144 100 173 100 3 Values Percentage of Total Values Percentage of Total Values Percentage of Total 76 45 85 46 102 46 4 2 4 2 4 1 29 17 32 17 37 16 7 4 7 3,83 8 3 20 11 21 11 26 11 6 3 6 3 6 2 12 7 14 7 17 7 3 1 3 1 3 1 7 4 7 3 8 3 1 0 1 0 5 2 3 1 3 1 3 1 0 0 0 0 0 0 0 0 0 0 0 0 168 100 183 100 219 100 so for example all 3 tables in a worksheet, all tables had different row lengths and i want to hightlight automatically 3 largest percentages values in range between "Percentage of Total" and "100" which is the sum of percentages in each tables.so for Table 1 all of cells between "Percentage of Total" and "100" will be hightlight,for table 2 highlight values are 23 21 15 (1st column), 22 21 15 (2nd column), 20 19 15 (3rd column)and for table 3 it would be 45 17 11 (1st column), 46 17 11 (2nd column) and 46 16 11 (3rd column) Is there a way to do that?
Using Filters to Auto-Update Complex Formulas
Hi, This is my first post here. Hoping someone here may be able to assist me. I have the below spreadsheet. There is currently 500 rows of data. At the Top is a Summary Grid with formulas summarizing the data below (Rating, Employee Level, etc. ) I'm also showing an example of one of the formulas in Cell F3. The other cells contain similar formulas. Ask: How do I get the Summary Grid to only display the data based on the rows visible, which is determined by Column T filter selections. For example, if the user selects "Level 4 Manager 2" and this manager has 10 employees, how do I get the Summary Grid to display just the data based on those 10 employees (versus the total 500). I've seen videos/sites that use the Subtotal or Aggregate formula, but it appears those can only be applied to specific functions, not a more complex formula. Is this possible?
