Recent Discussions
Playing with conditional formatting
This formatting is something I used to restructure the way I wrote formulas between 2015 and 2018. In the original I used VBA but now, as often happens, worksheet formulas used within conditional formatting are sufficient. The formula defining the condition is = DIRECTREFλ(A1) //Function to test for the presence of direct cell references DIRECTREFλ = LAMBDA(cell, IF(ISFORMULA(cell), REGEXTEST(FORMULATEXT(cell), "\b[A-Z]{1,3}\${0,1}\d{1,6}\b")) ); The original was pretty effective as a training aid to avoid the practice of relative referencing and use defined names! That said, not many followed my lead! Mind you when I posted a discussion on Chandoo it didn't meet with overwhelming support, though subsequent events in the form of spilt ranges have made my life so much easier! The post did however stimulate more discussion than I had anticipated. The A1 notation is an abomination that has no place within serious spreadsheet design -- discuss? | Chandoo.org Excel Forums - Become Awesome in Excel
Template for Novices
Hi All We have mechanics out in the field an they are to write weekly report. but they struggle to ad in pictures and when they do it, the picture quality become poor. so is there a way to make a template where placeholders for picture and text are fixed? ie 4 by 4 for pictures and how do we keep the picture quality Br Rune
Top n vs. Others in Excel
Hi all, I'm seeking some help because I'm kind of new to the more intermediate stuff in Excel. I have an Excel table with the following columns: Subcategory in column A, Brand in column B, Region in column C, Year in column D and Values Month in column E. I want to create a PivotTable and a Pivot line chart from this PivotTable that ranks the Top 5 Brands vs. Other Competitors by each region. For added context: There are 5 subcategories, 3 regions and 25 brands. Currently, I've tried grouping the remaining 20 brands as "Other Competitors" vs. the Top 5 brands within a selected region and possibly all regions (when no selection is made). I'm seeking a solution similar to this... Please mind the colours. I will sort those out later. But, the problem that I'm faced with is that upon selection of a region, the PivotTable won't update to the Top 5 brands of a selected region because they've already been grouped. How can I make this more dynamic so that I'm able to show The Top 5 brands vs. Others? Please help. EDIT: My operating system is Windows 10 (64-bit) and I use Excel 365 (Desktop version). For reference, I've attached a link to a sample file. https://1drv.ms/x/c/b2d878e32a062614/IQC1wcnwLICcQasOfnGcwKn0ASjpXp9xQ6rjnOP10Jal5cc?e=HaXEWd Thank you all once again.
Intune iPhone apply policy based on user
Hello, I am pre-enrolling corporate iPhone in Apple Business Manager to point new mobiles to my Intune and deploy a default set of policies. Im wondering if there is a way to specify want device configurations are applied at the "build" stage based on the persons using the phone. For example, we have certain people who need specific configurations versus the default. There are large number of these people, and I'd rather do this at build time hands off rather than having to come back and add a phone to a group to get a policy etc. I also prefer not too if possible, to set some kind of filter etc ahead of time to differentiate what policies a phone gets. Again, it's based on the user, not the device so prefers to not have to go into a portal and set a filter of some sort to make this happen. Any suggestions if this is even possible.
PLEASE HELP ME!!! Problem With Excel Formatting Not Working?
PLEASE HELP ME!!! I created an excel workbook for tracking fitness workouts, I record the data such as weight lifted, number of reps, and rest times between sets. I formatted the cells so they express your rest times in terms of minutes and seconds (I used the custom "H:MM" format of time option). But whenever I record the amount of time you spend during cardio exercise, the formatting gets COMPLETELY SCREWED UP because when I type 28:44 (28 minutes and 44 seconds) of cardio duration, it instantly turns into 4:44 (4 minutes and 44 seconds). But if I type 20:00 (20 minutes) of cardio duration, it stays as 20:00 (20 minutes) and it never turns into something else. Why do some of the numbers like 28:44 transform into a complete different number when I enter them? I uploaded 3 screenshots below to better express what I mean.
Index & Match Formula Not Working
In broad terms, I'm on sheet 2 and wanting to show the contents of a cell from sheet 1. Basically, I want whatever is in column C of sheet 1 for the row that has column A in Sheet 1 matching A2 in Sheet 2 AND also has column B in Sheet 1 matching A1 in Sheet 2. I want the contents of that cell to show in Sheet 2. I've made this formula, but clearly I'm missing something (names of sheets have been changed, as the actual ones are people's names): =INDEX('Sheet 1'!C:C,MATCH('Sheet 2'!A1,'Sheet 1'!B:B),MATCH('Sheet 2'!A2,'Sheet 1'!A:A)) Any help would be appreciated.Excel charts: revenue and margins over a time period
Hi all, I want a chart showing the development in revenue and margins over a period of three yrs. I want the revenue to be marked on the left hand x axis and margins to be marked on the right hand x axis (secondary axis). I can't quite get it to look the way I want. See the attached picture. What I want is for the margins (currently shown as lines across the three companies) to show as lines across each company over the time period. So basically one line across company A, one line across company B and one line across company C. Appreciate any help! Best regards, Kris
How to create a multi-tiered percentage-based bar chart?
Hello, I would like to create a multi-tiered percentage-based bar chart based on the data found below (test data evidently). Column B and C add up to 100%, Column D and E add up to 100%, and lastly column F and G add up to 100%. I would like each set of variables to equate to 100% on the graph, as the source data is percentage based anyways, but all be organized in their own separate row on the graph underneath the employee name. I have included a diagram drawn in MS paint to portray the desired output (with an accompanying legend). Thanks in advance! Employee Name Number of Sales Made % Number of Sales Made from Other Competitors % Number of Calls Made % Number of Calls Made from Other Competitors % Number of Individual Employees % (always is 1) Number of competitor employees % John 28.57% 71.43% 30.00% 70.00% 16.67% 83.33% Stacy 41.67% 58.33% 38.71% 61.29% 20.00% 80.00% Richard 47.06% 52.94% 47.06% 52.94% 14.29% 85.71% Andy 42.31% 57.69% 40.48% 59.52% 10.00% 90.00%Worksheet tabs to include date from a cell
Hello , I have a worksheet with four tabs. Cell H1 in both tabs 1 and three contains a date. I would like to include that date in the tab name in the following format: for Tab 1 "AR - as of (the date in H1)" and for Tab 3 "AP - as of (the date in H1)". The dates in the tabs would update whenever the date in cell H1 is updated. I am using Microsoft 365 Apps for Enterprise, version 2510, Build 19328.20178. Thank you for your assistance.PLEASE HELP ME. Excel Time Formatting Not Working?
PLEASE HELP ME!!! I created an excel workbook for tracking fitness workouts, I record the data such as weight lifted, number of reps, and rest times between sets. I formatted the cells so they express your rest times in terms of minutes and seconds (I used the custom "H:MM" format of time option). But whenever I record the amount of time you spend during cardio exercise, the formatting gets COMPLETELY SCREWED UP because when I type 28:44 (28 minutes and 44 seconds) of cardio duration, it instantly turns into 4:44 (4 minutes and 44 seconds). But if I type 20:00 (20 minutes) of cardio duration, it stays as 20:00 (20 minutes) and it never turns into something else. Why do some of the numbers like 28:44 transform into a complete different number when I enter them? I uploaded 3 screenshots below to better express what I mean. '
Conditional formatting in SharePoint lists using JSON
I have my conditional formatting working if I only refer to one number. As can be seen in the image below if the cell I want to format has the number "1" in it the formatting works. I would like the same formatting to work if for example the number was less than "2" or between 3 and 5. I've tried several options with starting with "=if...", but it either breaks the conditional formatting or doesn't make a change. I have been able to find an example that matches the attributes. Full disclosure the conditional formatting continues so I can apply different colors to other individual numbers. I'm hoping the if I resolve on the set of numbers the others will follow the same framework.
OneDrive/SharePoint permission problem
Hello, the problem is that we have a user which wants to share file(s) with another user. If he shares the file and he gives him permissions for read and write the he is still not allowed to open it, even if he askes for permissions an those will be granted it still does not work. This works (or does not work) with several files, but not with all. If those files ares shared with other users it works instantly. We have another user with this problems, the only thing they have in common is, that both were deactivated over a period of I think 5-6 months or even longer. It is not with every file, and it does not matter if those files were uploaded in SharePoint or OneDrive and it does not really matter who uploaded it. If I e.g. downloads a file which does NOT work and I upload it again it works. I am not sure if I described it properly, but this problem only appears for 2 users which were disabled and unlicensed for a longer period of time. Is the only way to fix this to delete the account and create a new one, so that a whole new User ID is created and nothing is related to the old user or is there a proper way to handle it, because to delete the account and create a new one is more or less the last thing I want to do. Thanks in advance
Loop development has seemingly stopped
Our team adopted Loop since many of us prefer the personal knowledge management system style of Notion or Obsidian to other classic note-taking and sharing software. However, many core features are still not present that have been Day 1 features of these other tools, and a quick check of the Loop Roadmap leads me to believe that most features will be security/governance focused. That's disappointing if true, because right now Loop is clearly inspired by those tools, but incredibly far behind in a way that makes it hard to justify their continued use. For example: Cannot embed documents inside Loop-- in Notion you can just drag and drop a PDF to upload, and the /embed command lets you put an interactive document inside the page Cannot select multiple pages to re-arrange structure No Copilot to perform page cleanup-- Notion lets you use AI to fix formatting, and it works very well. No command palette-- this is a must for operating in a knowledge management system No Mac app No mind map a la Obsidian I could continue to produce these examples, but I am hoping to find out that once some core governance features are completed, Microsoft will be focusing some development efforts on improving this platform-- we hope it is not abandonware a few years into it's launch.Remove "Ghost" Excel sheet object from VBA
Hello, I am unable to remove these "Ghost" excel objects left behind after deleting the sheet. I have tried multiple methods that I found on the internet to remove these objects, but nothing works. The sheets are not hidden. The sheets do not existing. That is the "hard coded" name created when the file is created from copying the "CAD" or "CAD_Template". The "remove" button is grayed out. I tried basically everything CoPilot could tell me to remove this. This is what it looks like below. When I run the program, the program creates "CAD4" as the next hard coded name.Database in an "inconsistent state" and other errors
Hello. I was directed here for help by Microsoft Tech Support because the problem is "file specific" and not at the app level. I am not computer savvy and have never used a forum like this. Tech support just kind of dumped me here and said "have at it," so any guidance, help, etc. would be appreciated. I use Microsoft Office 365 as a personal/individual subscriber and my Access program started issuing error message over the past week. The biggest concern and problem is around db called Comic Books and I've attached the error message. When I click OK, it attempts to repair, fails and issues the second message. Another database--an earlier copy of Comic Books from mid December-- opens OK, but has its own problems, such as when I attempt to simply copy a table (see third error message). I don't know if these are related. Can anyone help me? Is there any hope for me ever regaining access to the Comic Books database which was last accessible and working on January 4? Thank you.Entra ID Rationalizes Session Revocation for User Accounts
Microsoft is rationalizing the options to revoke sessions for a user account in the Entra admin center by removing an old revoke MFA sessions button. That seems like a perfectly reasonable thing to do. When administrators want to revoke sessions for an account, the best way is to create a PowerShell script to perform the necessary steps. That way you don’t need to worry about buttons. https://office365itpros.com/2026/01/09/revoke-sessions-button/
Move based on value VBA
I have what I hope to be a fairly easy to solve problem in my VBA code. I have a tab where each row is a different project and each project has a handful of tasks. When the project is complete, the entire row moves to a completed projects tab. My problem is that some of the formulas that make up the tasks update when moved and reference the incorrect cell. I am trying to copy/paste values before the row moves from one tab to the other to no avail. The formula that I am really trying to paste the value of is in column D. Could anyone help me out? Thanks in advance! Dim xRg As Range Dim xCell As Range Dim A As Long Dim B As Long Dim C As Long A = Worksheets("Deliverables").UsedRange.Rows.Count B = Worksheets("Complete").UsedRange.Rows.Count If B = 1 Then If Application.WorksheetFunction.CountA(Worksheets("Complete").UsedRange) = 0 Then B = 0 End If Set xRg = Worksheets("Deliverables").Range("S1:S" & A) On Error Resume Next Application.ScreenUpdating = False For C = 1 To xRg.Count If CStr(xRg(C).Value) = "Complete" Then Sheets("Deliverables").Select xRg(C).EntireRow.Copy Destination:=Worksheets("Complete").Range("A" & B + 1) xRg(C).EntireRow.Delete If CStr(xRg(C).Value) = "Complete" Then C = C - 1 End If B = B + 1 End If Next Application.ScreenUpdating = True Sheets("Deliverables").Select ' End Sub
Events
You’re passionate about what you do, and we’re passionate about empowering your potential. Microsoft 365 Community Conference - is your chance to keep up with AI, build game-changing skills, and take...
In-Person
Recent Blogs
- 3 MIN READHere’s a look at how OneDrive evolved in 2025!Jan 09, 2026
- 2 MIN READPaste your link onto selected text and Word automatically adds a hyperlink.Jan 08, 2026
