Forum Widgets
Latest Discussions
Moving a column of text data into 3 columns of data?
I have a column of text data cells 1,2,3,4,5,6,7,8,9 and longer. I want to create 3 column of data to graph and manipulate Cell in Columns. 1,2,3 3,4,5 5,6,7 8,9,10 and longer. So i need to create 3 columns of data from 1 column of data. I am using Mac Excel 16 and I can not make this happen. I have tried all sorts of solutions. Help? Thank you,STOCKHISTORY and Stock Data not working
Is it only me? Or everyone else having the same problem? My Excel 365 cannot use STOCKHISTORY Function anymore. It shows #connect! Error. Also, I cannot use the stock data anymore. (The other data types are not functioning as well.) (The error message says "Sorry, we are having a temporary server error. We are trying to fix this problem.") Is it only me? Or everyone else is having this problem?
Hi, I need help. I'm creating a calendar, based on events at our farm, which are on different dates.
Each event has its own column, the name of the event is at the top of the column, and the different dates it will occur are listed underneath it. I need to get this event name to automatically appear on an interactive calendar I made in the next sheet. (The calendar shows the date and weekday of a certain month in a certain year, you can change the month and year to whenever you want), I've tried the xlookup functions but I can't seem to get it working. Please help if you can! I'd be happy to take advice.
Need help adding calculations to pivot chart
Hi Experts, I have hourly data collected from our shared solar system (14 lots). The feed has three phases and it is the analysis of each phase I'm interested in, in particular I want to plot how each lot within each phase is tracking to a target percentage share as the month progresses. I've started by creating a pivot table with a calculated column giving the running total of the solar power delivered to each lot over the selected period for the selected phase. The problem is, I want to see the running totals as a percentage of the total delivered on any given day for the phase. I've created an illustration to show what I'm trying to achieve - the light green cells are what I'd like to see instead of the running totals given in kWh. The source file can be found on onedrive https://1drv.ms/x/c/c95331b296c5ed04/IQBuIcCgK-boRJGmS1e3EKnLARVxjCZTHEpusuvwckW_dDc?e=tS7i4i Some of the more dedicated followers will probably recognise that this is a follow up question to my recent question that was so skilfully answered in super quick time. I'm hoping I'll be able to create a sheet worthy of sharing with other people who are implementing a shared solar system. [Trivia: I live in NSW Australia, where the government is giving grants to apartment buildings who implement a shared solar system that gives each lot a fair share - where the amount of the allocation is based on the same formula that calculates the strata fees. Larger lots pay more fees and get more solar. My research so far has shown that the sharing system is not quite working as I expected, but I need to make the whole workbook more bulletproof before I share it publicly] TIA RedNectar
Chat with Copilot popup on every Excel launch
An ad for Copilot shows up every single time I open Excel. Clicking Not Now closes it, only for it to reopen again when I open Excel later. Is there any way to disable this or remember my selection each time? It is frustrating to have to deal with it all day long. I do not have a Copilot tab in File > Options. Optional connected experiences is already disabled. Microsoft® Excel® for Microsoft 365 MSO (Version 2511 Build 16.0.19426.20218) 64-bit Windows 11 Pro 25H2
Disable Auto-Fit/Auto-Wrap on Web?
About a week ago Excel rolled out a new feature to me that offered to auto-fit my cells whenever needed. Not knowing what it was, I accepted it and turned it on. Now, I want to turn it off and cannot find it anywhere. I've tried following https://support.microsoft.com/en-us/office/undo-automatic-formatting-in-excel-54eba206-110c-445a-89f1-c4eb67a36bd4?showContactUsNav=False&ns=EXCEL&version=90instructions, but these instructions are for the app, not web, and the issue doesn't replicate on the app. Below in E46 is an example of the issue. I want to paste links without them auto-wrapping my text or auto-fitting the column. I have tried turning wrapping on and off again in this column, but it doesn't work. I could manually disable the wrapping every time I enter a link, but I would much rather just turn this feature off.
Funktionen werden nicht angezeigt
Hallo. Ich habe das Problem, dass manche Funktionen nicht für die Auswahl angezeigt werden (funktionieren tun sie aber). D.h. wenn ich zB in der Zelle anfange zu schreiben =xverweis.... erscheint die Syntax-Info nicht, auch über die fx zum Einfügen werden die Funktionen nicht gefunden/angezeigt. Woran kann das liegen, was kann ich da machen? Aktuell sind es xverweis und datedif, die ich vermisse. und es sind sicher noch weitere. Ich habe es mit zwei verschiedenen Excel 365 Abos versucht, bei beiden dasselbe Problem. Danke für Tipps.
