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, Anupam
REF 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!Making 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.Excel
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 Mandy
Data 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?"
Reporter 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ée
