Recent Discussions
Formula
I am using a spread sheet program to keep track of my stock. First col is the ticker. Second col is the number of shares I own. Third col is the dividend that the stock pays per share. The fourth column is the total amount the stock paid. (Col 2 *Col 3). These figures/formulae are all on the same line. The dividend per share changes so I delete the figure in the third col. after the stock pays. I then enter it again when the new dividend is known. . When I do this I Inose the formula in the fourth col. Is there a way to hold this formula?Filter Form with Like and Or
Hello Experts, I am having a tough time adding a condition to a filter on a form. It works with 1 condition but not sure about the OR part (sq, dq) Maybe it is correct. The error I get is "Type Mismatch" see pic below. The row highlighted is the Remarks line. It seems odd because the fields are "short text" in the underlying table. Do you see an issue with the OR statement? If not, any ideas why I would be getting that error knowing that the fields are text? Private Sub txtEndUser_AfterUpdate() 'http://allenbrowne.com/ser-28.html If IsNull(Me.txtEndUser) Then Me.FilterOn = False Else Me.Filter = "[Remarks 1] Like '*" & [txtEndUser] & "*'" Or "[Remarks 2] Like '*" & [txtEndUser] & "*'" Me.FilterOn = True End If End Sub here is the table showing they are short text. the table is imported. as a reminder, I have no issues with 1 condition meaning it filters fine.
Power Automate - when a form is submitted: Other choice text
I have a flow that will write details from a form when submitted. One question in the form is a choice field with an "other" option where they can enter text for the other option. I would like the flow to write "Other" as the choice column value in the SharePoint list and then take what they type in the form for the other text to be written to another SharePoint list column as the text of the other option. This will keep the column formatting on the list view consistent for the values in the choice column. Any ideas?
All of a sudden Excel not highlighting selected worksheets
Historically, when selecting multiple worksheets in excel, the selected worksheets would be highlighted with green underline. Now, the selected worksheets are no longer highlighted. This makes it difficult to identify the selected worksheets. Appreciate thoughts on how to resolve.
Office Beta Channel Version 2502 Build 18516.20000
My beta channel Office suite updated to Version 2502 Build 18516.20000 this morning, and now Outlook crashes any time I select an email or open a calendar object. Not even opening the email, just selecting it crashes. Even when opening up in Safe Mode. I've also performed Quick Repair and Full Online Repair with no change in behaviour. In Word, just opening a document crashes out as well. Faulting application name: OUTLOOK.EXE, version: 16.0.18516.20000, time stamp: 0x6789eeaa Faulting module name: wwlib.dll, version: 16.0.18516.20000, time stamp: 0x6789ef67 Exception code: 0xc0000005 Fault offset: 0x0000000000342823 Faulting process id: 0x8220 Faulting application start time: 0x1DB6CF4DBDD3639 Faulting application path: C:\Program Files\Microsoft Office\root\Office16\OUTLOOK.EXE Faulting module path: C:\Program Files\Microsoft Office\root\Office16\wwlib.dll Report Id: aac213cd-b3fa-491c-950c-a7d2037d5e68 Faulting package full name: Faulting package-relative application ID: Faulting application name: WINWORD.EXE, version: 16.0.18516.20000, time stamp: 0x6789f0d8 Faulting module name: wwlib.dll, version: 16.0.18516.20000, time stamp: 0x6789ef67 Exception code: 0xc0000005 Fault offset: 0x0000000000342823 Faulting process id: 0x7AE8 Faulting application start time: 0x1DB6CF52B1B34CD Faulting application path: C:\Program Files\Microsoft Office\Root\Office16\WINWORD.EXE Faulting module path: C:\Program Files\Microsoft Office\Root\Office16\wwlib.dll Report Id: 871a616d-7e30-4fac-8aae-19cf4a537e16 Faulting package full name: Faulting package-relative application ID:Generate Dollar Signs in Word Template
I am using a Word template to create and invoice with Power Automate. I have two tables in the Word template. Two of the columns in each table should display numbers as currency, specifically dollars. The generated template only shows the content as numbers. Can I correct this, and if so how?
Movable shapes within set range or rating slider
Good morning everyone, I have been struggling with a document for some time and would like to ask the community here for potential solution. I created a document with a table with columns below. For a large part of the table, I want them to be read only. In one column, the user should be able to input free text. In another column, I'd like to put in a slider image for each row, and allow the user to move a bar shape or a triangle shape to indicate the rating. I somehow get what I wanted with the text fields and the checkbox fields with "Review --> Protect --> Restricted Editing", but not the slider/shape fields. Have anyone done this before or have some ideas as to how this can be realized? Thanks!
Sorting numbers
Hi, I have a excel sheet with x number of columns. I have formated the rows so that if there is a specific number it is marked in red. See picture below. The numbers that are marked are Top row 0 - 3 and 9 - 13. So numbers 4-8 shall not be marked Middle row 0 and 6 - 13. So numbers 1-5 shall not be marked Bottom row 0 - 1 and 7 - 13. So numbers 2-6 shall not be marked What I now whant is to count all columns that are not marked red. As of now I do this manual with marking with "1" below and use function Count. Someone that can help me with a function for this? Most thankful.
Print a booklet
I want to print a booklet of my excel pages. To do this I would print 2 pages to a sheet, horizontal orientation. It will be 12 pages, so on the first sheet of paper I want to print page 12 on the left side of the page, and page 1 on the right side of the page. On the back of that sheet I want to print page 2, then 11. On the second sheet I want to print page 10, and 3 on the front of the sheet; and page 4, and 9 on the back of the sheet. Then I can collate them, fold them in half and staple the fold to product a 5 1/2 x 8 1/2 booklet. Can I do this in excel? In other words, can I choose in what order the pages are printed?
Sequence Formula for Deadline Calculations
Good afternoon. I have been tasked with calculating the deadline dates for start dates on rolling courses. I am currently working to develop the best system. Currently, multi people have been manually type in/copy/paste bulk data. The deadline spreadsheet for example has 15 different tabs on it. There are a few quirks here. For example, our December start date is always longer, due to the holiday/break schedule. I have included a brief data set, including the sequence formula I used to calculate the deadline. Some of the program courses last 3 weeks, some 6 weeks, others can be 9 - 11 weeks. I am intending to try the sequence formula in excel to see if I can develop a formula for this process to be more automated and easily calculate, without error. I am looking for input/thoughts/reference to understand the sequence function to aide with my query or any other formula suggestions. Is there a better way to semi-automate this process? Where I can complete "shells' or "templates" and pull (either from an excel formula or simple copy/paste). I am thinking since there are 15 tabs, I can set it up to pull from other tabs. There is a blank line in between the different class starts intentionally. This is formatted specifically to read easier. This is a rolling list, so new start dates will be added at the bottom, and then we need to calculate and publish the deadlines as the new start dates are added at the bottom. So on the Full-Time data set, you can see where new Start Dates have been added. When new start dates are added, I need to find an easy way to go in and add the deadlines. The deadline is based on the last day of the calls. So English 1 had its last week on December 30, 2024. This means January 3, 2025 is the last day of that class. The deadline will always be the last day of class, unless the issue occurs during the last week of class. Then, students will get an extra 7 days. The last week will always have a different deadline. Typically, we publish the class start dates for 1 - 3 years in advance. As this gets updated, the deadline database must also get updated to add the new class start dates and then determine and publish the deadlines associated. I appreciate any thoughts/suggestions when it comes to formulas or different patterns that may develop better formulas than I have. I hope the information I provided was helpful and clear. I tried to provide informational knowledge as needed. Please let me know if there is anything I can clarify to assist better. Thank you all in advance: Sample Data Set with Class Start Week Of Date, Class & Deadline & Formula used to calculate. Warm regards, KristinaSearch Formula help!
Help you lovely genius people. Is there a formula to check a text string in a cell and if it contains a sequence of 4 or 5 numbers in a row return the 4 or 5 digit number? For some backstory... I'm looking at a 2 columns of data from Xero and within some of the cells there will be a Job reference, but the text strings are not in any specific order/format. I was using this formula before... =IF(M1824="Expense",IFERROR(UPPER(MID(E1824,SEARCH("JOB",E1824,1),3)&"-"&MID(E1824,SEARCH("JOB",E1824,1)+4,4)),UPPER(MID(D1824,SEARCH("JOB",D1824,1),3)&"-"&MID(D1824,SEARCH("JOB",D1824,1)+4,4))),"") Columns D & E contained the text and this returned a result in a format I could then use for lookups i.e. "JOB-####", or an error if "JOB" wasn't in either column. This meant a lot of manual checking of error cells. To add to the fun, we have just breached JOB-9999 so I'm now also having to look for JOB-10000+ (I don't envision having to worry about 6 digit job reference but if there is a way to future proof then bonus.) Annoyingly, some of the data is system generated when invoices are processed and POs are matched, but some comes from expense claims and is manually entered, so although Xero will always give the reference as "JOB-####" or "JOB-#####" sometimes the reference will appear as "Job ####" or "job no ####" or just "####" or any other random combination the engineers think to put on their expenses, so if i can just reference a cell and pull back any 5 digit number and if there's no 5 digit number then look for a 4 digit number? I hope someone out there can help, I've tried a few things but can't seem to get anywhere close to a useable result. Living in hope, MarcusHow can I count unique clients in a each year
Hello all. I am trying to obtain the number of clients that shoped in 2018, 2019, 2020, 2021 and so on. I tryed to use Count(Unique) but it gives me the total number of clients that have shoped in our history. When I try to add a formula that restricts the formula to each year, i obtain an error or a wrong number. Each customer has a customer ID. So I have two columns in column A is the clients ID and in column B the year he shopped in. Thank you in advance.Multiple replace vba
There is a quick way via a macro or function to replace many misspelled words. I have attached an example file. In column A there is the database with the correct entries, in B the incorrect entries that refer to C separated by ";" and in C the entries that should then be replaced. If an entry is not present in the database like Pink in my file, once replaced it will remain in column B I will add it to the database later but this is a very rare evntOneNote videos disappearing
Today all of my embedded YT videos in my OneNote book disappeared all of the sudden. They had been working but suddenly are not. The OneNote is within a Teams group and when I view the videos there only placeholders show- no videos. When I view the videos in the OneNote app and try to play them and error message pops up and tells me the video doesn't exist, which it does in YT. The links have not changed or been altered. Any help is appreciated. Our IST cannot figure it out.Email to be sent when a content is entered in a cell in Excel
Is it possible to set up an automated email notification when a specific cell in an Excel spreadsheet is updated? I'm responsible for tracking reimbursements for expense reports for a number of employees, some will have reimbursements for out-of-pocket expenses. Can I set up an automated email notification that will tell me when they enter data in "a cell" and also tell me in the body of the email. The name of the person on the report (this info is in a particular cell in the report). The date of the report (this info is in a particular cell in the report). Note: Each employee completes their expense report and will have their own separate Excel Expense Report. If I can do this then I will not have to look through every report to find the few with Out-Of-Pocket expenses to be reimbursed.
Selecting MultipleCells on Microsoft Excel using an External Touch Screen Monitor
I recently attached an external touch screen monitor to my laptop and initially I was struggling to select and highlight multiple cells on Excel Randomly the cells started appearing with a circle on each edge making it easier to highlight more cells up, down, left and right Now again randomly its changed again without me changing any settings at all and I can no longer highlight multiple cells using the touch screen monitor The only workaround is to use the select objects function but this does not always work nicely to highlight the cells Any ideas as to how to get the circles back again on a selected cell to make it easier to highlight multiple cells? This is how it looks now but havent got a picture of how it used to be when it worked wellIf formula problem
Hi all! I am new to using excel so I appreciate your help in advance :) I created a spreadsheet to track multiple choice answers for a quiz. This is the formula to track if people got the answer right: =IF(F3="a",1,IF(F3="b",0,IF(F3="c",0,IF(F3="d",0,IF(F3="-",0,NA))))) However, someone answered "bd" instead of only selecting one and the formula resulted in an error. How do I correct the formula so that the answer would be "0" in that case? Thank you?What do you think of thunks?
OK, so the most likely response by far is going to be "I don't". However, I tried one of Omid Motamedisedeh's regular challenges and found it a suitable problem for exploring some of the lesser known byways of modern Excel. The challenge is to pick out locally maximum values from a rolling range. What I did was to write a function that used MAP to select one cell at a time, using DROP to remove the initial cells and TAKE to return a range of 5 cells with the active cell in the middle. The direct route to solving the stated problem would be to calculate the maximum value within each range immediately, but I was interested in the more general problem of "could I return the array of ranges in a form that would support further analysis?" As shown, the following formula ROLLINGRANGEλ = LAMBDA(values, n, LET( rows, SEQUENCE(ROWS(values)), MAP(rows, LAMBDA(k, LET( m, QUOTIENT(n, 2), rng, TAKE(DROP(values, k - m - 1), MIN(k + m, n)), rng ) ) ) ) ); gives and array of ranges error, but simply by enclosing the 'rng' variable within a further LAMBDA ... LET( m, QUOTIENT(n, 2), rng, TAKE(DROP(values, k - m - 1), MIN(k + m, n)), LAMBDA(rng) ) will cause Excel to return an array of functions, each one of which would return a range if evaluated. In the attached workbook, a number of formulae are based upon this array of functions = ROLLINGRANGEλ(dataValues, 5) = MAP(ROLLINGRANGEλ(dataValues, 5), LAMBDA(ϑ, ROWS(ϑ()))) = MAP(ROLLINGRANGEλ(dataValues, 5), LAMBDA(ϑ, ISREF(ϑ()))) = MAP(ROLLINGRANGEλ(dataValues, 5), LAMBDA(ϑ, AVERAGE(ϑ()))) = MAP(ROLLINGRANGEλ(dataValues, 5), dataValues, LAMBDA(ϑ,v, MAX(ϑ()))) = LET( rollingMax, MAP(ROLLINGRANGEλ(dataValues, 5), LAMBDA(ϑ, MAX(ϑ()))), FILTER(Data, rollingMax=dataValues) ) The first simply returns #CALC! errors on the worksheet which is the normal response to a Lambda function defined on the grid. The second formulas uses ROWS to show that the ranges are not all the same size, the third shows the returned objects to be range references and not simply arrays of numbers, the forth is a rolling average while the fifth is a rolling MAX. The final formula returns the solution to the problem, being a filtered list. The purpose of this post is to demonstrate that Excel, which started out as a 'simple' spreadsheet program, now contains a very different programming environment that shares a function library and uses the grid for input/output but, other than that, has very little in common with 'normal' spreadsheet practice! A related survey can be found at https://www.linkedin.com/feed/update/urn:li:activity:7285432559902068736/
Events
You care about keeping up with the latest tech, building your skills, and helping your business succeed. And that’s why we’re here. This year, the Microsoft 365 Community Conference returns to Las Ve...
In-Person
Recent Blogs
- 4 MIN READFlexible billing for Microsoft 365 Copilot, Pricing updates for annual subscriptions & Teams Phone Today, we are announcing several commercial licensing and pricing updates. These updates include i...Jan 23, 2025
- 8 MIN READLearn about new features now available in Microsoft Whiteboard!Jan 23, 2025
