Forum Widgets
Latest Discussions
Table Merge from Web
Dear Experts, I need to export the below in a Single Table from below link :- https://portal.3gpp.org/desktopmodules/Specifications/SpecificationDetails.aspx?specificationId=3283 But when I use PQ, it gives me into different Tables, and I have to combine them Manually as below:- How shall , I merge them all into a Single Output? Thanks in Advance, Br, AnupamSolved55Views0likes5CommentsREF Broken Formula Link Issue
Hello! I have created 6x files which contain formulas that link back to a specific cell from multiple external files all stored in the same drive. However, when opening each of these files, either half or all linking to external files break and become #REF erasing the formula that links to the external sheet. Strangely, this doesn't happen consistently as sometimes only half of the links break across some or all files, sometimes all of them, and a mix of working and broken links in the same files. I'm not sure why this is happening and am finding it difficult to troubleshoot. Has anyone experienced this before or know why this might be occurring? Any insight or help would be greatly appreciated! Thank you!KatDalJun 12, 2025Copper Contributor34Views0likes2CommentsMaking Python-in-Excel worth it
I feel like Python-in-Excel has huge promise. Embedding a Seaborn correlation matrix in an analysis sheet with a couple lines of readable code? Keeping multiple dimensions of data in one cell efficiently? Making models that involve recursion and iteration without all the workarounds of LET/LAMBDA? Yes please!! I've messed around with it a lot but my experience has mostly been negative and from reading comments it sounds like a lot of others have had bad experiences too. A local version that was unlimited for free would be ideal of course. But I'm going to assume for a minute that isn't possible for business reasons. Most of my frustrations relate to these three things. So maybe if we could get these it would be worth it to use? A way to track usage and buy more credits so we don't get stuck with #BLOCKED! with no recourse Improve the xl() function so it works with variables inside it instead of just literals. e.g. foo = "B4" ; bar = xl(foo) currently doesn't work but it should. The error messages need to always tell you what line number the error is in I'm curious if other folks have tried it and agree or disagree with this wish list.EricAshtonJun 12, 2025Copper Contributor62Views1like3CommentsExcel
Help, I have a spreadsheet with various data added and want to filter this to only show certain data. However the sheet is not filtering out all blank cells. I have removed the filter, resaved the document and ensured all cells are blank and tried again - and failed again. I have the same document saved this different data that is allowing the filter to work correctly. Any ideas on what I am doing wrong? thank you in advance MandyMandy66Jun 12, 2025Occasional Reader3Views0likes0CommentsHow to count text from a multi-line cell
Hi, I have an extract from a system that when opened in Excel looks like this in one multi-line cell: text text text text text Not all of the points 1-5 will contain text after them e.g. it could also look like this: 1. text 2. 3. 4. 5. On the sheet there are hundreds of multi-line cells that each contain the points 1-5 and I need a way to count how many of the 1-5 points for each cell have text after them. Does anyone know of a way to do this please? Many thanks for your help.Solvedsjaybee58Jun 12, 2025Occasional Reader58Views0likes3CommentsLinks to Spreadsheet on Android homepage gets greyed out
I have spreadsheets on OneDrive that I access via Excel Mobile. Since I used them every day, I created links to each of them on the android homepage. This has worked successfully for me for a very long time, but now the home page links being are being greyed out. When I open Excel to recreate the link, Excel does not list the file in the recent history, and I must go through the process of finding the file, opening and re-pinning it. I have tried opening the file from the laptop and making it favorite, but that doesn't help. Both Favorite and Pin fail. I have spent hours both alone and with Microsoft Tech Support trying to fix this. I tried everything they or I could think of, but no joy. They gave up, and suggested I ask the community, so I am asking.SolvedShelPrinceHotmailJun 12, 2025Copper Contributor22Views0likes1CommentData info in separate date columns
I need to put data information in separate date columns in the same excel project. Let me give you an example. The project have 4 quarters lasting 3 months each. I need to put data information on each quarter column. People who use our service and we put information in quarterly report column. See this example below. Name. - age - gender - race Quarter 1 (Jan to March). Quarter 2 (April to June) Quarter 3 (July to Sept), Quarter. 4 (Oct to Dec) I need to separate the group of data into each quarter column so it won't repeat in other quarters using the formula on excel. I have used COUNTIF to calculate the group for each quarter column. I tried DATE but I got error, "#NAME?"Davidbass67Jun 12, 2025Occasional Reader33Views0likes1CommentHow can I customize the font in the Conditional Format
I can´t customize the Conditional Format. I can´t change the font type. Only appears a message: "This is a cloud source and will be downloaded when applied". I have tried all recomendations but I´m still having the same problem.LuisDLP2025Jun 12, 2025Copper Contributor53Views0likes1CommentReporter une donnée excel
Bonjour, Je dispose d'un tableau à 3 colonnes (A : Nom ; B : Classe ; C : numéro de chambre). Je souhaiterais que lorsque je rentre une donnée dans la colonne C, qu'automatiquement dans la colonne E sous le numéro de chaque chambre que le(s) nom(s) se reportent. Avez-vous une idée de la formule à utiliser ? Bonne soiréeNico2776Jun 12, 2025Copper Contributor111Views0likes6Comments
Resources
Tags
- excel42,802 Topics
- Formulas and Functions24,832 Topics
- Macros and VBA6,433 Topics
- office 3656,071 Topics
- Excel on Mac2,665 Topics
- BI & Data Analysis2,397 Topics
- Excel for web1,934 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,654 Topics