How to chart this?
Need help on how to calculate then chart this. I have a number of pairs, which I’m imagining as a flow, but with some loops back, and branches: From To A G G C C D C A G F B E E F F E F D I’d like it to figure out a table/chart (but with arrows) like the attached image. It may have optional paths. Doesn't have to be like a flow chart, if there's another way for excel to analyze it. I don't *think* this is a complex b-tree sort of problem... TY in advance.
Count U slots
Dear Experts, I have a case like below:- So, there's a Worksheet "Calc" below where we have Slots from 0~19 two times from Col (C~V) and (X~AQ); In ,Sheet2 we have the Logic on how to count the U slots:- 1D --> 1 symbol DL 2DD --> 2 symbols DL 2DU/2UD --> 1 symbol for UL, 1 symbol for DL 1U --> 1 symbol UL 2UU --> 2 symbols UL 1S (for split) --> Half symbol for UL, Half symbol for DL Can you please provide a formula for Column AS and AT to count the U slots, using above Logic, Attached is the Worksheet.
Formatting / Inputting Help Needed
Hello! I am trying to put together a spreadsheet detailing media I own (4k, Blu Ray, DVD, etc.). I would like to include the run time but I'm running into an issue with inputting and formatting. I can set the format of the column as hh:mm:ss but I'm forced to hard input the colon between the hh / mm and mm / ss. Is there any way I can format the cells / column where I don't have to use the colon and it will automatically input it. That is, a movie is 1 hour, 23 minutes and 45 seconds, and I want to just type in 012345 instead of having to manually type the colon between the 1 and 2, and between the 3 and 4. Thanks!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?"
Summarize multiple columns of varying row lengths into one column.
I am copying old data into into Column B and add my own findings to Columns D and G. I'm looking to summarize the data as depicted in columns P&Q. What I've got making the M&N columns is M: =IF(NOT(ISBLANK(A4)),A4,"") N: =IF(NOT(ISBLANK(B4)),B4, IF(NOT(ISBLANK(D4)),D4, IF(NOT(ISBLANK(G4)),G4,""))) I don't know how to account for a variable number of rows between sample ID for column and multiple items from the columns B,D,G printing on different rows in the desired data set. Thanks in advance.
Toggling autosave on saves despite saving has been disabled in VBA
I have an Excel spreadsheet that is used to calculate certain data and give a printable report. For the report patient information must be given. That information must not be saved. To accomplish that I've put following code into ThisWorkbook, and it works mostly as needed: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Cancel = True 'Cancels any request to save the file End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.ThisWorkbook.Saved = True 'Tells Excel that the file has already been saved (this prevents Excel from requesting that you save the file when you close it) End Sub And autosave has been disabled with code: Private Sub Workbook_Open() If Val(Application.Version) > 15 Then If ActiveWorkbook.AutoSaveOn Then ActiveWorkbook.AutoSaveOn = False End If Yet, when autosave toggle is clicked on, Excel saves the file. If the autosave is left turned on, after few seconds it displays the message, and doesn't allow saving any more, but at the moment the autosave is turned on, the file is saved. I've found a workaround. If I mark the file as final version, it can't be saved, but then it also needs additional click of the "Edit anyway" button before any data can be inserted. The file is available to other users via SharePoint, I can't manage file permissions. Is there any other way of dealing with this?Filter formula for looking up data in a table
Hi, I,m looking for a formula that can lookup and return results when I select the name and return the vehicles at the top eg - Andy Scooter Bicycle Car Bus Thanks for any help Scooter Bicycle Motorbike Car Bus Lorry HGV Andy x x x x Brian x x x x Carl x x x x x Dave x x x
Why do I have a #NAME error in my sequence formula?
Hi all I have Microsoft 365 with Excel version 2506. I started using =SEQUENCE formula today and it was working then randomly all my =SEQUENCE cells changed to #NAME I have checked the formula for typos multiple time, even had Copilot check for typos. I then had Copiolit create me a formula, and that still didn't work. Is there a reason I am getting #NAME error when there are no typos and my Excel is up to date? Thanks in advance. J
Unable to Embed OneDrive Shareable Link in iFrame due to CSP Restrictions
Hi, Objective: We want to embed an Excel file (hosted on OneDrive for Business) within an <iframe> inside our Angular web application. The user should be able to: View the Excel file inside the iframe. Edit the content directly in-place. Save changes back to the original file in OneDrive. Architecture & Authentication Flow: We explored two approaches: Client-Side (Angular) Direct Graph API Access via Application Permissions We attempted to obtain a Microsoft Graph access token directly from the Angular app using https://login.microsoftonline.com/{tenant}/oauth2/v2.0/token. However, this call fails with a CORS (Cross-Origin Resource Sharing) error, which prevents the token exchange in the browser. This is due to Microsoft not allowing CORS access to token endpoints for confidential flows from client-side applications for security reasons. We found no configuration or setting in Azure Entra (Microsoft Entra ID) that allows bypassing this. 2. Server-Side Graph API Access via Application Permissions To work around the CORS limitation and meet our goal of centralized company-owned file management, we shifted to the application permission flow on the backend: Our server (Node.js/.NET) uses a client credentials flow to acquire an app token. It performs the following tasks: Uploads the Excel file to a company OneDrive location. Generates a shareable editable link via the Microsoft Graph API (/createLink or /createUploadSession). Sends that link to the Angular client to render the file. Issue: iFrame Embedding Blocked by Microsoft CSP When we attempt to embed the shareable Excel URL into an <iframe> on the Angular page, the browser blocks the request with the following error: Refused to frame 'https://some-link.my.sharepoint.com/' because an ancestor violates the following Content Security Policy directive: "frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com teams.cloud.microsoft *.office365.com goals.cloud.microsoft *.powerapps.com *.powerbi.com *.yammer.com engage.cloud.microsoft word.cloud.microsoft excel.cloud.microsoft powerpoint.cloud.microsoft *.officeapps.live.com *.office.com *.microsoft365.com m365.cloud.microsoft *.cloud.microsoft *.stream.azure-test.net *.dynamics.com *.microsoft.com onedrive.live.com *.onedrive.live.com securebroker.sharepointonline.com". Is there any way to achieve our goal?
