Forum Widgets
Latest Discussions
Calculating a running average grade
Hi I am a teacher and want to add to my student record sheet a running average grade. I would like to set it up so that the average updates throughout the year when more test data is added. However this means that there will be missing data, as students will not have completed all the tests until the end of the year. This is my data. The different written tests have different grade boundaries and the grades shown are populated by different vlookups based on the % scored in the test. As they have different boundaries, my idea was to assign each grade with a point score, lookup this point score with a vlookup, then average these point scores before looking up a grade. I have started with this formulae (not quite got to the stage to look up the final grade). Im not sure how to make larger sorry I have tried using If functions to solve the problem of missing data but as soon as there is missing data i get a #VALUE! error Is there anyway to get around this and work out the average with these gaps? ThanksA-T24Feb 12, 2025Occasional Reader13Views0likes1CommentHow to stop excel from updating dates.
Hi there, I have a running order list that we keep track of what is ordered when and when things are received. we are using a check box to initiate when the item was received. my problem is that the when i go to update an item the previous dates update to the current date. How can i prevent the date in column H from updating to keep historical dates? example of the document and the formula i am using. thank you in advanceEvoss87Feb 12, 2025Occasional Reader17Views0likes1CommentExcel selects wrong cell
Hello, I am here to report on what seems to be a common issue... After working for a few minutes in excel, when I go to click on a cell, the wrong cell actually gets selected, and it is usually several cells above or below the cell my mouse is hovering over. I sometimes have success in saving, closing and reopening the book, but not always. Excel Office 365 version, updated on schedule, as always.HandFoodlerFeb 12, 2025Copper Contributor38KViews3likes22CommentsSorting data by time.
Dear community, I have this Excel file with lots of data that I have to filter. My issue is that I have a lot of duplicated coordinates (Column E and F); however, I can't delete all duplicated coordinates because I would like to keep valuable data from other columns such as G,H,I,J which has unique values. Question 1: Is there a way to filter the data from column A based on time ? For example, I would like to remove all rows that have less than 5 minutes in between each other. Question 2: Is there a way to compress the duplicated coordinates from column E and F without removing the data from the G,H,I,J columns ? Thank you in advance, and I appreciate your help.Stefan22Feb 12, 2025Copper Contributor13Views0likes0CommentsCELL NAME DISPLAYING
I gave a name to a Cell and the actual "name", in this case (CALL), is displaying inside the cell underneath of what I type. I had try deleting the name I gave and start again but it does the same. I had tried deleting the rows and adding new fresh rows and it does the same. If I delete and add the name to any other cell, this problem does not happen. It's only those cells. The moment I custom the cell name, it shows back again. This problem it's been bugging me for a long while and I can't find any forum or link on how to... How can I hide the name cell? Is there any option for this? Any help will be appreciated it. Thanks in advance!KrislonFeb 12, 2025Occasional Reader47Views0likes5CommentsHelp creating a matrix table
Good day wonderful people, I am trying to create a matrix table that shows correlations between types of issues people may be worrying about. The end result is to enable me to bring it into Power BI and utilize the chord visualization diagram to show where certain issues are connected and the strength of those connections. I have an excel sheet with a range (se below). The first column is a unique client ID. As the data may be collected over a period of time, the same client IDs may appear more than once (if they come back to the service provider). The data may include up to a maximum four issues that they are worrying about, and these are in adjacent columns to the client ID. As an example, in the below table, homelessness has low level interconnectivity with 'Priority Debt'; 'Disabled' & 'Mental Health' as they appear as issues alongside with that string; "Mental health" has a strong connection to "Non-Priority Debt" (and of course vice versa) with it occurring each time the other is mentioned. This is what I am aiming to show. Due to the way in which this data is laid out (from a database export), I am struggling to bring it into a matrix table (if that is the best method) and then on into Power BI. I've spent quite a bit of time in the forums, but can't find a way to apply the learning in them to the table output, or the right way to transform the data (via power query or otherwise) to help identify the interconnectivity. If anyone can point me in the right direction to solve this, I would be most grateful! Thank you in advance :-)95Views0likes5CommentsRotating label in horizontal stacked bar chart
Hi all, I've created a horizontal stacked bar chart in excel, but the label of the level 1 category is displayed vertically in the diagram. How do I rotate this, so it is displayed horizontally? Thank you in advance! 🙂 KrisKristoffer_Toft_JensenFeb 12, 2025Occasional Reader9Views0likes1CommentCharts getting cut off when printing to PDF
Hello, User is experiencing an issue where when printing or exporting to PDF, their charts are not scaled to fit the page. Simply by opening page layout dialog on print window and closing it again (no changes made) the chart is exported correctly. However, initiating a print/export before this, it is cut off.kadomonyFeb 12, 2025Copper Contributor3.7KViews0likes1CommentHow to fill a range of Sheet A with data from Sheet B by repeating this action for each value
Hi, I have two sheets A & B. Sheet A has a table where A1:H1 is the header. The range C2:C9 of this table is blank but there is data in the ranges A2:B9 and D2:H9. Sheet B has data in the range A1:A43. I have to fill the range C2:C9 of Sheet A with data from Sheet B by repeating this action for each value in Sheet B.SolvedDan1ExcelUserFeb 12, 2025Copper Contributor80Views0likes9CommentsErreur référence cellule MACRO/VBA
Bonjour à tous, Je travaille actuellement sur un projet de récapitulatif des congés pris par mes salariés. J'ai utilisé des formules et macro pour automatiser mes calculs, cependant, si les "périodes de congés" sont vides, une erreur s'affiche et bloque toutes les autres formules. Le tableau est mit à jour tout au long de l'année et j'ai besoin qu'il soit utilisable sans cette vilaine erreur "#REF!". Pourriez-vous m'aider ? Voici les infos techniques : 2 feuilles : "Contrat Initial" : feuille du tableau "MACRO" : feuille de données, calendriers des jours fériés etc. Formules utilisées : Total des jours hors jours fériés J'ai besoin d'afficher le nombre de jours ouvrables (lundi à samedi) hors jours fériés Calcul des samedis sur la période J'ai besoin d'afficher le nombre de samedis sur la période de congés saisie. Samedi est défini comme le 6ème jour de ma semaine, selon le système européen. Le calendrier J'ai saisi les données des jours fériés sur la feuille "MACRO" sur la plage A12:F22 Merci d'avance de votre aide !SolvedEzjakaFeb 12, 2025Occasional Reader22Views0likes2Comments
Resources
Tags
- excel42,192 Topics
- Formulas and Functions24,460 Topics
- Macros and VBA6,351 Topics
- office 3655,935 Topics
- Excel on Mac2,617 Topics
- BI & Data Analysis2,332 Topics
- Excel for web1,878 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,608 Topics