Recent Discussions
Conditional Formatting (?) Issue
I'm trying to change the colour of the font in a cell based on the value in an adjacent cell but can't get the formula to work. Help please! Example: Cell A Cell B ABC xxxxxx DEF yyyyyy GHI xxxxxx If Cell A = ABC, I want Cell B to be Bold Red font If Cell A = DEF, I want Cell B to be Bold, Blue font If Cell A = GHI, I want cell B to be Bold Green fomnt Thanks in advance.4Views0likes1CommentMacro to copy
Hello all you "Brilliant Minds" here is a chance to prove your "Excel-ence. I want to copy a value to one cell from the source which is random and as I haven't a clue about this stuff I asked Microsoft CoPilot. Being on the 4th version Where Microsoft excel still will not accept Microsoft CoPilot's creation, I am appealing to the Community. So here is your chance to prove that you are smarter than CoPilot. Here we go, everything but attach a file. If anyone is interested send me an email so I can send a couple of small files. Donald77Views0likes4CommentsCombine Similar Matching Rows Into One and Add Column Using Power Query
I have two data sources (XLSX and CSV) that have been loaded into Power Query, had transformations applied to them, and then merged based on the Asset and Path columns. Asset and Hits are a part of the CSV file and Title and Path are from the XLSX. The CSV file cuts off data after 35 characters so the cell might only contain partial information. There is also dirty data that has been cleaned up, resulting in duplicate row items, even though they are similar. See the example below: The two Assets are the same but because of the cut off and dirty data, they are listed as two different items. What I am trying to do is combine these duplicates into one row, with the Hits added together, so the merge finds the corresponding path. I tried to keep only the first 66 characters but there are other assets in this list that rely on the characters past 66 to be unique.10Views0likes1CommentHow import data from Json API
Hi, I have a website and people can import data from my website by an API key to their own website. But now I am trying to import the data which is a service list to an Excel sheet. This is my website API document URL : https://neofollower.com/panel/api/docs I want to import the "Services List" it has two parameters : key = Your API key action = services and the API URL: https://neofollower.com/panel/api/docs the API key is unique for every user My excel is Professional Plus 2021 I tried with Data-> New query -> From other resources -> From web then : URL parts: https://neofollower.com/panel/api/docs HTTP request header : key = my API key action= services but i don't get any results (it says the API key is disabled or didn't connect, but API is work perfectly in other websites) what should I do?889Views0likes2CommentsBest way to get rolling 12-month totals
I am using Excel for Mac version 16.102. I have data in a Table which is basically date, category & value. There are many other columns I use for filtering. I pivot this data to get totals by month within year but I hide the yearly totals and just have the grand total. My pivot table is filtered to include\remove high-level category data. I have a Timeline which allows me to select the date range of my pivot. I have a number of slicers to facilitate filtering to get the dataset totals I need. There maybe a better way but the above works. My ask is how do I go from the above to easily get a rolling 12-month totals for say Jan 24 - Dec 24, Feb 24 - Jan 25, Mar 24 - Feb 25 etc etc? I can move the timeline which gives me the correct answer but I'd like to be able to see the rolling totals for the last 12-months at a glance without having to keep moving the timeline. Eventually I'd like to graph the last 12-months so I can see movement over time. Can I do want I want with a pivotable or do I need another approach? Thank you for your help.136Views0likes14CommentsHow to Add a Loop Workspace to a Standard Teams Channel
The update to allow team members to add a Loop workspace as a channel tab is now rolling out and should be available worldwide soon. Microsoft is currently putting a lot of emphasis on Loop and its almost read-time collaboration capabilities are turning up in many places within Microsoft 365, like Copilot Pages. Will Loop replace OneNote eventually? That’s a big question… https://office365itpros.com/2025/05/22/loop-workspace-teams-channel-tab/182Views0likes2CommentsLooking up specific period financials from multiple period worksheet
Hello, I have the following sample data: The data from Column I onwards is in a different worksheet in the layout that you see above. I need to be able to bring in the July data as shown from Cols C to E. One easy way would be to concatenate the month with the Sector and Currency headings in rows 3 & 4. For example, JulyADRUSD and then do a nested xlookup to bring in July ADR USD Accounts Receivable information. However this would mean creating a new row for my concat field. Is there any other way we can fetch the required information? Hope you can point me in the right direction. Thank you.121Views0likes5CommentsV Look Up - not for an exact match
I want to look up a name from one column of data in another but the names are not exactly the same. For example one column has just one or two names and I want to see if they feature in a column of data with between 1-5 names. How can I do this please?21Views0likes1CommentSave Recent Font Color
Is there a way to save recent font colors so that they don't need to be selected with each new Word session? I use the deep blue color shown below constantly, and not just as cosmetic thing. That color has good contrast with other text and is easy for my eyes to pick up. I would just like it if I didn't have to go select it all the time. I'm hoping maybe there's a registry setting that will make that color automatically available in the below list, or maybe it can be made part of a template or something. Thanks in advance for any help that you can offer! --TomSolved37Views0likes2CommentsCaptions for images, including sub-captions
Good morning, I’m using Office 365 (Office 2019 at home). I wanted to ask if it’s possible in Word to create captions for images, including sub-captions, with all the corresponding indexes reflecting the hierarchy. I mean something similar to the photo below.43Views0likes3CommentsThe Small Business Owner’s Guide to Using AI 5 Immediate Wins with Microsoft 365
Running a small business often means wearing multiple hats—manager, marketer, bookkeeper, and customer service rep all in one. Fortunately, artificial intelligence (AI) tools built into Microsoft 365 can give you back valuable time and help you work smarter, not harder. The best part? You don’t need to be a tech expert to start benefiting today. Here are five immediate wins you can unlock with Microsoft 365 AI features: https://dellenny.com/the-small-business-owners-guide-to-using-ai-5-immediate-wins-with-microsoft-365/11Views0likes0CommentsBooking not available for everyone
Dear Community, We are currently experiencing an issue within our tenant related to the Microsoft Bookings App. While the app is enabled and accessible via browser for users in a specific group, some users are unable to add the app directly to their Teams interface without submitting a request. At this point, we have not been able to identify the root cause of the issue. I might be a policy issues that only we can solve. Has anyone encountered a similar problem or could suggest possible solution? Thank you :)Typography: Expand Character Spacing by Relative Value
Right now I can only "adjust" character spacing by absolute values, measured in points (see below). I could swear this is new—haven't I always been able to expand character spacing by relative values, measured in percentages?26Views1like1CommentAutomatically update document styles
So this might come across as daft, but I have an issue with style sheets and existing documents I'd have thought that selecting this option, when applying a style to an existing document, would force the document to adopt the styles defined in the DOTX. If I change a style on the orignal DOTX I'd have thought the changes would be reflected in the document. But it doesn't and it does not refresh the document to reflect the changes made. Am I doing something wrong here? If not, how can I force existing text for accept the new styles. ps - Re-editing the existing document context isn't an option because we've lots of documents covering some 630+ pages which we regularly update 4 times a year.49Views0likes4CommentsPage colour fill effects option missing
I am using version 16.101 of Word on MacOS 15.6.1 I want to set an image as the background of my document's pages, and have done so in the past by going to page colour<fill effects. Now I can't see that option anywhere in desptop or online. I can't use a watermark because I need the image to cover the whole page, not stopping at the margins. Does anyone know how to fix this?41Views0likes3CommentsLegend setting in Excel charts - possible to set default to go to top of chart
hello I hope you are well. When I add a legend to a chart in Excel, it invariably defaults to the bottom or side, rather than the top. Is there a way to change this default behaviour? Thank youSolved29Views0likes2CommentsExcelAt40 – Day 11: Lookup Wars – VLOOKUP vs XLOOKUP
Hello Excel fam 👋 Today’s post dives into the differences between VLOOKUP and XLOOKUP — with a visual comparison, practical tips, and even a quiz to test your lookup knowledge. We also covered how to use XLOOKUP with IFERROR for cleaner formulas and wrapped it all up with a cheat sheet. Would love to hear: 👉 Are you still using VLOOKUP? 👉 What’s your favorite XLOOKUP trick? #ExcelTips #ExcelCommunity #LookupFunctions #OlufemiBuilds #ExcelAt4076Views0likes1Comment
Events
Recent Blogs
- 7 MIN READExcel is the world’s most trusted canvas for working with data, powering everything from household budgets to Fortune 500 companies, scientific research, operational planning, and classroom learning....Sep 29, 20254KViews9likes0Comments
- Formula completion autocompletes formulas when you type = by referencing the context of your workbook.Sep 26, 2025729Views1like1Comment