excel
44742 TopicsData Formatting
Dear Experts, I have a Data like below :- Each row can have 1 or more RNTIs( seperated by ",") and their DCI( UL_01 or UL_00), I want to put them in a format like in Col - I~P gave examples for the 1st two entries. Attached worksheet. Thanks & Regards Anupam ShrivastavaSolved63Views0likes3CommentsAllow removal of "Copilot Suggestions" from right-click menu
I have been using Excel for decades and CONSTANTLY use the right-click menu for quick access to basic functions (e.g., "Insert"). Ever since "Copilot Suggestions" was added to the drop-down list, it always throws me off due to its placement. I have Microsoft 365 on Windows 11 Pro. I have searched for ways to remove this from appearing there and the result said "go to File > Options > Copilot and uncheck the 'Enable Copilot' box". However, when I attempt to do that, there is NO "Copilot" option available! PLEASE allow removal of "Copilot Suggestions" from the right-click menu OR at least the option to move it to the bottom (so it isn't in the way of things used ALL the time). I realize that Copilot is a great resource for many users, but I am confident in my Excel skills and in my ability to research/learn new skills the "old school" way, so I have little use for this feature now and would prefer to hide it.473Views6likes6Commentsunpivot data and handle merged cells without using Power Query (Unpivot_Toolkit)
Hey, guys!! I’ve been working on a set of functional Excel Lambdas to solve a common headache: transforming "Wide" human-readable data into "Long" database formats without having to open Power Query every time. =UNPIVOT_PLUS(table, [no_of_cols], [no_of_headers], [attribute_names], [value_name], [remove_errors], [remove_blanks],[pad_blanks_with],[pad_errors_with]) Don’t worry about the full list, most use cases only require 5 arguments. I've included a table of default values at the end. Merged Cell Support: Automatically handles fill-down/fill-right logic for merged headers/columns. Bonus Helper: SPLIT_INJECT =SPLIT_INJECT(array, target_indices, delimiter, [ignore_empty], [match_mode], [pad_with]) It targets specific columns, splits them by a delimiter (like TEXTSPLIT), and expands the entire table horizontally while keeping all other columns perfectly stable. Optional arguments match TEXTSPLIT defaults. Feel free to tear this apart or adapt it for your own edge cases. I’d love to hear how you end up using it! You can grab both functions from my GitHub Gist https://gist.github.com/Medohh2120/f8553c149684e39bb499249e39f01017. Argument Description Default Behavior table The array or range of data to unpivot. Required argument (no default) [no_of_cols] Fixed left columns to keep as identifiers. 1 [no_of_headers] Top rows used as headers, handling merged cells. 1 [attribute_names] Header name for the unpivoted attributes . "Attribute" [value_name] Header name for the unpivoted values. "Value" [remove_errors] Excludes grid rows with formula errors. FALSE [remove_blanks] Removes grid empty cells and empty strings. TRUE [pad_blanks_with] Value to substitute for empty cells. Leaves cell blank [pad_errors_with] Value to substitute for errors. Leaves error as-is315Views2likes3CommentsCorrelation Study with Filters
Dear Experts , I have a data like below( Attached worksheet) And want study the correlation between SNR[0~3], there will be 6 combinations as below:- I want make like this but with Filters/Slices for the "File.Name" & "SSB or TRS" & "Carrier Index", different colors for different Carrier Index(0 &1) Thanks & Regards Anupam Shrivastava16Views0likes0CommentsExcel workbooks keep breaking
Hi All, Sorry if this is not the right place to ask, I'm new here. Since a couple of days, my Excel workbooks keep breaking. When opening specific files, Excel states the file needs to be repaired. Everytime certain formulas are being deleted and the values are just pasted as is. I haven't had any issues with these files in the past. Previously I used a license which I bought online via a third party. It seems the issues started after an update. I switched to a license which I bought directly from Microsoft. I did a clean installation, removed all the previous versions files but the issue still exists. For a couple of days I can open the files without problems. And then yesterday excel showed an update was available and excel had to be reopened. After doing so, the issues came up again. I have a Office Home 2024 License, Excel version 16.106.1, on macOS Tahoe 26.2. T.I.A83Views1like1CommentPython in Excel - Missing from desktop Excel but exist in web Excel
Good Morning! Yes, again this topic :-( When I join to a professional forum I also search for the topic I having a problem with. Found a lot of similar questions but I could not find a post with a solution. Maybe I was not enough attentive and patient but I did not. Well, we are a University in Hungary, and we have Microsoft 365 A1, A3 and A5 licenses. I attahced a screenshot which shows: in the desktop Excel I got #CALC! error msg when I type =PY and press TAB. But it works in Excel on the Web version. So the root of the problem cannot be the license, right? Of course I saw this article about "Python in Excel availability": https://support.microsoft.com/en-us/office/python-in-excel-availability-781383e6-86b9-4156-84fb-93e786f7cab0 Our licenses are based on user, not device so no, it cannot be that the computer is a device with shared license: My Excel version is on: So the version and the channel are also OK. (OK?) I am also a Global Adminisitrator in our tenant, so I could check if the Connected experiences and Optional connected experiences and all related possibilities are disabled or not: no, it is not disabled. On "Microsoft 365 Apps admin center" : https://config.office.com/ ... I did not find any policies which controls those options so in "Policies for all users" policy I modified all these settings from "Not configured" to "Configured" and "Enabled". In my Excel the Trust center related settings looks like this: Of course my Office package up to date, I ran the Update Office and Update License command from Excel. Did not help. I went also to https://admin.microsoft.com site if I can find any related setting, but did not. I also tried to Sign out and Sign back in Excel - did not help. Finally, as our computers are in Hybrid environment (so our users are logging in inti on-prem AD, and their properties are synchronised to Azure) I have cerated a Group Policy object (I am also a Domain Admin), which also allows connected and optional experiences for all domain users: I should not mention: did not help :-( I have checked if the GPO is applied or not by running GPRESULT /R, it applied, it is in the registry. But despite all the settings so far - nothing helped. The Python in Excel feature in desktop Excel do not want to work. But it does in web based Excel. I would be very happy to receive any ideas from anyone. Or if U say I should go to official Microsoft support, then I go. Have a nice day! Regards, Andras /sorry for the very detailed case description, but maybe easier and quicker if I "aswer" all usual questions in advance/21Views0likes0Comments