Recent Discussions
max corresponding to a value which may be in 1 or multiple sets
Hi G6 is showing error because F6 is not found in D15:D50. what would be the simple process that F6 is searched in D15:D50 and D56:D91 and returns value from col K instead of an error whether or not that value exist in either of the sets.
Conditional Formatting multi rule help!
Hi all, I've asked a very similar question to this before, but the helpful answers I got previously now don't seem to work for my spreadsheet. Please could someone talk me through how do this: Below is a spreadsheet we use to tell us when a patients prescription has come into the clinic. We manually put this data in. I need a set of rules as follows if possible: If there is a date in the 'Date of Injection appointment' cell (in this case F13) and there isn't anything in the 'Prescription received in clinic' cell (in this case O13) then I would need the patient name cell (in this case D13) to turn a different colour depending how close the date of injection is. Does that make any sense?! So if the date of injection (F13) is less than 4 days from today and cell O13 is empty it needs to be filled red, if cell F13 is less than 6 days from today filled yellow and if cell F13 is more than 8 days from today then filled white. I'd really appreciate someone's help please. I'm losing my mind! Thank you in advance
Problems sharing files with users outside Tenant
An additional Sign In window appears for external users with whom we share files or folders through OneDrive and/or SharePoint. The window for entering the email appears (to validate that it's the intended recipient), but before entering the verification code, the Organization Sign In window appears. This sometimes requests a password, which can cause issues or even prevent users from sharing these folders with external users. Authentication flow example: Normally, step 2 is followed by step 4, but in my case, it's taking me to step 3 where I have to re-enter the email address I'd already entered in step 2. This isn't normal. In this case, there's no major problem with this email because it then asks for the verification code, and I log in without a problem. But for example, when I tried another email address, also from Gmail, it asks for a password to authenticate: Then I realized it's asking for my password because that email is associated with my GitHub account, and it's trying to authenticate with a password. However, this flow is incorrect because for authentication to SharePoint files shared with external users of the Tenant, it should only ask for the username and verification code. The fact that it asks me to enter my email twice, as in step 3 of each example, and that it occasionally asks me for a password, is incorrect in the flow, and I don't know how to change that.
REGEX+TEXTSPLIT
Dear Experts, I have a data like below in column"A":- And , I want to split it in the way like in "Yellow" So, after each consecutive Alphabet or number it should be splitted, I tried to do something in Column "B" but not succesful. Could you please share any solution if possible by using a comb of regex + textsplit? Thanks in Advance, Br, Anupam
Markup Panel appearing with every word document. Comments column now in some weird thing.
Good day, I am so confused I do not even know how to explain all the issues. 1) Opened a word document today that I closed yesterday. Opens up with some thing called a Markup Panel. Go to review and select no markup. Fine for now, but then appears every time I reopen the document, and all other documents. 2) Up until today, my comments were nicely formatted in a column on the right side of the screen. Now they are in some thing called a "reviewing panel" which is terribly formatted and located in the wrong place until I drag to to the right side. Is this something I have caused or some Word Update (God, I hope it is not the latter.) 3) Also, the little indicators next to the lines where the comments are located are no longer present, so the only way I know there is a comment on that line is by clicking on the comment in the stupid "reviewing panel" How do I get back to what I had yesterday? Thanks so much for your help. Dave
Recent Blogs
- Formula completion autocompletes formulas when you type = by referencing the context of your workbook.Sep 26, 2025
- Whether you're a data engineer building pipelines or data analytics engineer looking to optimize your data model or data warehouse, Copilot in Microsoft Fabric is your intelligent partner for acceler...Sep 25, 2025
