Forum Widgets
Latest Discussions
Charts 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.Help 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 :-)
Erreur 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 !
Sorting dates in Excel from oldest to newest is not working
Hi all, I would like to sort a date series in Excel, formatted as Mon Feb. 10, 2025 08:59 AM, from oldest to newest, but I can’t get it to work. Every week, I have to download a list from a program that uses this date format (see screenshot). I want to sort it in order from oldest to newest, but when I try to do so, the dates get mixed up. Downloaded list: 2. I select the cells and want to order it from old to new, then it gives me this: Does anybody has a solution for this? Thanks so much in advance! Arianne
Excel filters with live and non-live data
Hi, I have created a spreadsheet for our attendance tracking. The spreadsheet contains some live student and attendance data pulled from our MIS, alongside non-live columns containing weekly comments and attendance categories (excellent, at risk, etc.). This non-live data is not held within our MIS so cannot be part of the liva data feed. I need to be able to either filter or sort the data by attendance category. When I try to do this when highlighting the entire dataset, the functions are not available. This, I presume, is because the live and non-live data columns are acting as two separate entities. I can filter the attendance category but this doesn't also sort the live student data (so the attendance category is not related to the student data), or vice versa. I can extract the data as values into a different worksheet then filter, but this is time consuming and needs to be re-extracted each time the data feed is updated. Is there a way to filter from the original live and non-live data together (i.e. I could filter by absence category and this will also filter the live student data in the related rows)? (We do have PowerBi but we need to be able to have this in Excel to add weekly comments relating to attendance). Thank you in advance!
CELL 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!
Cell Value Comparison
Hi, Please can someone help me as I am tearing my hair out right now and Copilot AI is obsessed with header rows and no help at all. I have a spreadsheet with a load of numbers on it and various column formatting (general/dates/currency). I have a formula in a column that compares the difference of 2 other columns and returns the value. If either of the cells are empty then no value is displayed. For some reason the formula hates the value £121.80 and returns a negative value and I have no idea why. Here is an example My formula is =IF(OR(AC4="",X4=""),"",AC4-X4) on the selected cell. But you can see there are 5 negative values and are all £121.80 in AC. Please, any advice would be greatly appreciated! Thanks, H
