Recent Discussions
Movement in spreadsheet as form after enter
When using an Excel spreadsheet as a form, is there a way to move from one cell location directly to another cell location after pressing enter in the first cell? What I want to do is have the user enter the width in cell B7, hit enter, and have B9 become the "active" cell, then enter the length in B9, hit enter, and have B11 become the "active" cell, so on and so forth. Essentially I want to skip from one input cell to another without having to go through all of the rows. Not all "moves" from one cell to another would be exactly two rows down, other locations in the spreadsheet would require moves of 3 or 4 rows to get to the next "active" cell. All of my moves would be in the same column though. Thanks to all who look at this.
Drawing data from multiple spreadsheets
Hi, So I have multiple spreadsheets with animal numbers and their weights I want to combine it on one spreadsheet The problem is that not all the animal numbers are on all the tabs, so I need a calculation that will "skip over" the one's not there. So for example this sheet (28 October) there are animals without tags and we gave them numbers 0.1-0.3, and then below that you'll see that 24004 wasn't weighed on that day so I don't want the formula on the final sheet to bomb out. If there's some way to do this process faster than what I'm doing currently - one by one = and then selecting the tab and the corresponding weight and animal number. Please and thanks so much!
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.
Calculate Days in between Dates
Hey, So I have a create date and a end date and I want to calculate the days in between those days, NOT counting the start date and weekends and the formula I am using is giving me the incorrect days: It's giving me -2 when the correct days should be 0. You can't see it, but the L6-L34 are the holidays, which would be 7/4/2023. Any advice on why this is happening would be greatly appreciated.
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.
Recent Blogs
- Thanks to new enhancements in how images are anchored to surrounding text, screen readers can now detect and navigate floating images effectively.Oct 07, 2025
- In today’s fast-paced business landscape, small and medium-sized businesses (SMBs) face a constant challenge: do more with less and do it faster. The pressure to innovate, respond to market shifts, a...Oct 06, 2025
