Recent Discussions
combine multiple text into single line of text
Hi is there a way to combine all the cells into a single cell (of text) ignoring the duplicates/repeat values. i know concatenate but that function becomes very lengthy as ill have to define every cell into the function individually. is there any other function where i simply select the entire data (like an array) and it can do the required.
Complex formulae with data model
Over the years, I have developed a significant excel data sheet which has gotten slower and slower with time. I have discovered the idea of excel's data model this week and have learnt how to import the data I need from its source CSV to the data model and I now have a power pivot which looks like what I originally had in excel. What I would like to do next, is to replicate some of the formulae I had in excel to calculate if something should be counted or not. I would not want the red one to be counted as this row would have been counted in the previous month. In excel I was using the following formula- =IF(COUNTIF(B5:M4,">0"),SUM(Patient!B5:M5*0),Patient!N5) is there a way of achieving this with the data model or would I have to hardcode this into another sheet? I was trying to avoid doing this to minimise the number of formulae... Many thanks for your help...
Can a font become 'corrupted,' and how to replace?
This refers to MS Word from Office 2019, running under Windows 10 Pro. I have a somewhat large (10MB) Word .docx I've been adding to as time permits. It has text, illustrations, pictures and captions for the pictures in text boxes. suddenly, when I open the file, some of the captions are garbled. The font I used is Arial 10pt, bold and regular. The bold is just fine, the regular is garbled. However, if I highlight the garbled text and change it to bold, italic or any other font, it appears just fine. Here is an example of what I'm talking about. First the .docx as it appears on my screen: Then if I highlight that garbled text and change it to Bold, or any other font, it looks good: If I change point size the problem persists. It's just Arial Regular that garbles, and only in this document, and . Other .docx files using that same font display fine. Also, I can take this file and open it on my other computer, which is running Office 2010 under Windows 10 Pro, and it opens properly. I do have Word programmed to embed non-system fonts in the document, so I'm assuming that Word is fetching Arial Regular to display when opening the file on this computer, and that my other computer maybe has a good Arial Regular installation, which is why it looks good there. Something else I just noticed, referring to the two screenshots that follow. Other 10pt. Arial Regular that was NOT in a text box seemed okay in this document. But on close examination, the kerning seemed a bit off. So I changed that non-text box text to another Helvetica-style font and it did look better, but then when I set it back to Arial, it was garbled too. So do I have a bad Arial Regular on this computer? If so, why don't other documents show this problem. And, most important, how do I fix it? Thanks in advance, and... HELP!Sumif inside Xlookup
Can someone tell me how to sum within Xlookup please? Correct answer above would have been 65+5=70. I am looking for total qty, if part is "F" and Location is "OM". Main Table has two matches. My current Xlookup formula only selects one record. This Xlookup formulas only works for one unique record. Thank you in advance.mac Excel: can't select form Group Box
Hi, I'm using Excel 16.107 on a Mac. I have Developer mode enabled and placed form elements, including group boxes. What I've found is if I delete the text label for a group box, the group box then becomes impossible to select -- there's nothing to click on with my pointer. See attached. Any attempt merely selects the cell, not the group box. How can I select group boxes like this, so that I can delete it or edit its properties?
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
- 2 MIN READOne of the best ways to get value from the Microsoft 365 Community Conference isn’t just attending sessions, it’s helping shape what gets built next. The Research sessions at Microsoft 365 Communit...Apr 10, 2026
- Inspired by real work, this video series will show you how Copilot can help you with everyday tasks.Apr 10, 2026
