Forum Widgets
Latest Discussions
Formula needed to retrieve % of correct reviews for an employee, where reviews are on separate tabs.
Hello everyone! Thank you in advance for any assistance you are able to offer. I'm working in MS 365 for web on a windows cloud environment through a Citrix network. Looking for a formula that will populate one employee's evaluation results as a % correct for each of multiple worksheet tables of reviewed items (pass/fail). See attached workbook for details on what I'm trying to do. I would like to be able to choose an employee's name from a drop down on the RESULTS tab, select the months to begin and end a date range and have this return the total reviews and number failed for each 'Review Name' for that employee. Thanks again! :)SolvedMarcus_BoothMay 21, 2025Brass Contributor106Views0likes10CommentsStop Autofill from Incrementing Certain Cells
I am going to try to explain this the best I can. Please, be patient with me. It might take a few attempts when it comes to properly describing things. Thanks! I am making a spreadsheet that keeps track of the ages for characters in a series I am writing. There are MANY characters, each one with a different birthday. Each story takes place for a different date and year. Right now, there are about 40 periods of time, and those are at the top of the spreadsheet. So, I basically have a character name, their date of birth, and then the subsequent cells calculate how old the character is for that period. When I try to use the auto fill, it increments the cell so that it no longer uses the correct cell. In essence, it tries to use the cell next to the date of birth cell. It does the same thing when I try with the column as well. So, how do I get the autofill to use a static cell horizontally while incrementing the cell vertically? Or the other way around?ScrewygirlMay 21, 2025Occasional Reader31Views0likes2CommentsMacro for overdue expense card reports
Hi. I am trying to figure out a macro that will allow me to use data provided to create a system that allows me to see people who are late submitting their expense card reports. I would like to break it down so that I can see those who are 30, 60, and 90 days past due on submitting their reports. If there is anyone out there that can help me to automate this system rather than manually entering it I would greatly appreciate it. Thank you and have a nice day.nleydig9May 21, 2025Occasional Reader36Views0likes3CommentsNo access to group/ungroup dates in Pivot Table filter. Jan-24 and Jan-25 show as Jan only.
I'm trying to follow instructions I found for grouping/ungrouping dates on a Pivot Table filter. Using 365 (desktop app and web based housed on Sharepoint Cloud) The dates on my column are formatted as Date='Mar-12', so when I type in Jan25, it converts to 1/25/2025 but displays Jan-25. The day of the week doesn't matter, just Month and Year. Adding that column to the Pivot table as filter, shows... <12/1/23 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec >3/2/2025 I have data for Jan-24 and Jan-25, but they are lumped together. There is no option to right-click on the dates displayed within the Pivot Table Filter. What am I missing? Thanks!SolvedMarcus_BoothMay 21, 2025Brass Contributor63Views0likes2CommentsSum 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!SolvedLisaB1009May 21, 2025Copper Contributor250Views0likes12CommentsMatch/Index referencing incorrect row
I have a spreadsheet that I am working on in MS365. On sheet "A" I am drawing the following information: AGE (=G63) into cell S65 Weight Lifted (=F68) into cell S66 From sheet "B" (Reference data) Row 2 are the age categories (17 - 21, 22 - 26, 27 - 31, 32 - 36, 37 - 41, 42 - 46, 47 - 51, 52 - 56, 57 - 61, 62 Over. These are grouped as MDLAGE. Column A are the scores - 100 - 0 descending order. these are grouped as MDLPOINTS In cells B3:K49 are the weights lifted. The values vary by age and there are cells that are blank or have a "---" in them. These are grouped as MDL. The formula I am using is: Cell S67 - =MATCH(S65,--LEFT(MDLAGE,2),1) This formula is returning the correct column. Cell S68 - =MATCH(S66,INDEX(MDL,0,S67),1) This formula is referencing the INCORRECT row. It is returning row 40 instead of row 31 which is where the correct weight is listed. If I change the 1 to a 0 or -1 the return is N/A. I have tried multiple formulas to "skip" the blank or --- cells but nothing has worked. Any help would be greatly appreciated!Scout50May 21, 2025Copper Contributor73Views0likes5Commentsliste deroulante pas d extrait des donnees
Bonjour j ai bien ma une liste derourante (227 articles) dans ma cellule mais lorsque je rentre un nom dans cette cellule j ai le message cette valeur ne correspond pas aux restrictions de validation des données pour cette cellule. Le pb c est que je n ai pas de restriction. Quelqu un pour m aider SVP. Mercilaurence83May 21, 2025Occasional Reader24Views0likes1Commentinclude a static number when a cell has an entry
Hi all. I am setting up a spreadsheet to tally entry fees for a clinic and show (horse industry). There is a $20 arena charge for those attending the show only. I have a column for attending the show but only want the arena charge to be included when there is something in that column. The column in question is D, I've totaled the cost columns in C, E, G with the total in H where I add the $20. Would the 20 be better added in E but only if there is a number in D? what would be the formula? B C D E F G H I J Andrews, Susan 2 =B3*200 3 =D3*30 3 =F3*25 =C3+E3+G3+20 =H3-I3 Barz, Janica 2 =B4*200 4 =D4*30 6 =F4*25 =C4+E4+G4+20 =H4-I4 Bowman, Bonnie 2 =B5*200 3 =D5*30 3 =F5*25 =C5+E5+G5+20 =H5-I5SolvedpevendenMay 21, 2025Copper Contributor21Views0likes1Comment
Resources
Tags
- excel42,713 Topics
- Formulas and Functions24,782 Topics
- Macros and VBA6,421 Topics
- office 3656,052 Topics
- Excel on Mac2,659 Topics
- BI & Data Analysis2,382 Topics
- Excel for web1,929 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,647 Topics