Recent Discussions
Dynamically filter table on basis of range of criteria
Hi, I have a large table (150k rows) loaded to Excel from power query and I want to filter the description column (column N) dynamically on a couple of key words. It should be an AND filter so the column should contain any of these words and then result in a table showing column M, N and AH. Anybody any idea how to realize this keeping a mind the size of the table? many thanks, regards,
Can you create a Button that Opens a Pop-Up with Data from Spreadsheets
Good evening, I have moderate knowledge of excel, and some knowledge of visual basic and am trying to develop a personal trading journal log. My intent is to create a pop-up for trades that I can input a lot of detailed data and an image of the trade that will then auto-populate a brief information row for a quick glance, but will also have a button in the row that populates for each trade that, if clicked, will open a pup-up of all the information given including the picture, comments about the trade in reflection and review, etc. I have been searching for if this is possible and haven't really found any information on it, only things like pop-ups for inputting data. Can anyone help me determine if this is possible, and if so how? Thank you.
synchronising outlook calendars between accounts
Hello together, I've got 2 different 365 accounts and have the Calendar in use on both. I'm searching for a possibility to sync between the two calendars so that if in one of the calendars an entry is entered, it gets synced to the calendar on the second account that gets synced as well. The other way around as well. Any ideas? brRename Cell to Various Different Sheet Titles
Hi, I am trying to create a formula that allows me to have cells equal to the names of different sheets. I have read several interesting posts that created solutions for having a cell automatically change to the name of whatever its sheet is, however, I am trying to create a table that automatically fills out the rows as I add new tabs. For example: I add a new sheet and name it "March", the next column title in my table will be "March". Having to do it manually at the scale required would be quite difficult. I believe this may require the use of VBA, and my attempts to teach myself were not very fruit-full. Is this possible? Thanks in advance.Sorting Problem
I build computers for myself and for friends, and I built a spreadsheet for comparing builds. I have a well developed system of determining a standardized point value to each component based on price and performance, but that's not part of the issue. I am trying to get a list of the builds in order of their rank based on totals of the points. I am 95% of the way there, when there are multiple builds with the same point value, the list shows the correct number of entries for that point total, but it lists the first build name of that total for all the entries. It's not listing the different names for each of the builds with the same total. I'm including a screenshot of a simplified version of this setup (excluding all the calculations of the point values, just their totals) as well as a link to the simplified spreadsheet if it's useful. Cell K2 uses the formula =LARGE($F$2:$F$16,$J2) Cell L2 uses the formula =INDEX($A$2:$A$16,MATCH(LARGE($F$2:$F$16,$J2),$F$2:$F$16,0)) If anyone has a suggestion how to adjust or rewrite the formula to solve this issue it would be greatly appreciated! Lee https://www.dropbox.com/scl/fi/28e5jr65lbov3yp1u64v7/SortingProblem.xlsx?rlkey=rq50ubzz4x2w0yr3870i3gasn&dl=0
Substituting Text in Excel Lookup Formula
I'm keeping game weekly statistics in Excel. I have the Lookup formula below: =LOOKUP(7,[WeekX.xlsx]Game!$A:$A,[WeekX.xlsx]Game!$B:$B) The "7" refers to a player number. I'm using Week1 in the first week, Week2 in the second week, etc. I have many of these Lookup formulas in the one spreadsheet. I would like to substitute "WeekX" where the "X" can point to a spreadsheet cell value (i.e. 1 or 2 or 3, etc.) I've tried double quotes "" and Concat in the Lookup formula. I have not been successful. Any suggestions?
Replace all formulas based on a pattern
I have several formulas in my worksheet that follow a similar pattern. The formula is as follows. =IFERROR(INDEX('Data Tab'!O:O,MATCH(TEXT(A350,"0"),'Data Tab'!E:E,0))*C350,0) I want replace all of these formulas to exclude the TEXT function. The new formula should be as follows. =IFERROR(INDEX('Data Tab'!O:O,MATCH(A350,'Data Tab'!E:E,0))*C350,0) How can I achieve this using Find and Replace?
Sumifs or other solution for both vertical & horizontal criteria
Hi all, I would like to sum values from a matrix of vertical critiera (e.g. names) and horizontal ones (dates as well as other criteria). I am not sure the sumifs formula can actually do this. So far I am getting errors. Hence, I would be very grateful if someone had another simple way/ formula to have the results calculated. Example is as such: Criteria 1 (vertical): Names Criteria 2 (horizontal): Date (1st row) Criteria 3 (horizontal): "Plan" (only) i.e. (2nd row) Sum-up values: In the empty cells in the matrix of the 3 criteria 1st May 25 1st Jun 25 1st Jul 25 1st Aug 25 1st Sep 25 Actual Actual Plan Plan Plan Name 1 Name 2 Name 2 Name 3How do I Stop Word Switching to Multiple Pages View
I have a high resolution wide screen monitor. Every time I open a Word document in full screen, it switches to the Multiple Pages view (typically 2 pages, side by side). I hate this view! I can't read 2 pages at a time. I always want a single page view. Does anyone know if there is a way to stop Word changing to this view? I am using Microsoft® Word for Microsoft 365 MSO (Version 2202 Build 16.0.14931.20128) 64-bitTurning off email notifications about new comments in one certain file
Hi All! I found a solution to turn off all email notifications on new comments in my shared files (through settings on SharePoint), but it doesn't really solve my problem. In project files I work on with my colleagues, email notifications are helpful for monitoring workflows and streamline the process. At the same time, I'm an owner of yearly excel files shared with a big team in order to monitor the work on all clients and automate the visualization of it, but it gets commented on a lot and I don't need to get all of that on my Outlook. Is there any way to turn off email notifications about new comments for just one file without turning them off on all my shared files? Kind regards, Jakub Banasik
Sort in Query not Displaying
I have no clue how to word this. Basically, in a form I have a field called Members. This field is a drop down menu that lists all of the Members for a meeting via check boxes. I can then tick the checkboxes for the people who attended the meeting, click 'ok', and then when when I run the report, their names will appear. I don't need this information saved; just to display on the report so I can print it. Here's my problem. Not all of the members can vote, so I want the members who can vote listed first, and the rest of the members listed next. I've put in my custom sort formula in the Members query. When I open my Members dropdown box, they are listed exactly the way I want. However, as soon as I tick on the names and then click 'ok,' it's displayed in order of the primary key. When I run the report, the names are still sorted by the primary key. I've gone to every query and table I can find to create my custom sort, but it keeps defaulting to sorting by the primary key. It's driving me INSANE. Any idea why it's doing this? I've dug through google and haven't had luck finding an answer that works. Thanks in advance!Comparing two ranges of cells in an if function
I have two rows of address information that I have to compare. If cells A-R in row 2 are identical to cells A-R in row three then I want cell S inn row three two be returned if true and blank if false. I tried the below formula and it gives me a VALUE error. =IF(A2:R2=A3:R3,S3,"") It works if I dont compare ranges, for example if I only compare A2 & A3. How do I do this formula with the logical test as comparing ranges of cells in rows. First Name Last Name Grad Year Grade Level Description Dob Address Line 1 Address Line 2 City State Short Postal Code/ Zip District Resides With Address Line 11 Address Line 21 Address Line 3 City1 State Short1 Postal Code/ Zip1 Parent/Guardian First Parent/Guardian Last Jim Smith 2018 12 1/1/2001 123 Any Street x Any City State 10000 ABC TRUE 123 Any Street x x Any City State 10000 William Smith #VALUE! Jim Smith 2018 12 1/1/2001 123 Any Street x Any City State 10000 ABC TRUE 123 Any Street x x Any City State 10000 Mary SmithHelp with Vlookup
I have created a table with food items in a drop down list and I want to be able to select something from the list so that when entered it also puts in the calorie count of that item in an adjacent cell. I have one table with columns Breakfast, Lunch and Dinner all have dropdowns with the list of foods The adjacent column is for the calories. I have another sheet which holds the list of foods with the calorie count in the adjacent cell. Any ideas - please bear in mind I am very green with excelCopilot Audio Overviews for OneDrive Documents
Microsoft 365 Copilot users can generate audio overviews from Word and PDF files and Teams meeting recordings stored in OneDrive for Business. Copilot creates a transcript from the file and uses the Azure Audio Stack to generate an audio stream (that can be saved to an MP3 file). Sounds good, and the feature works well. At least, until it meets the DLP policy for Microsoft 365 Copilot. https://office365itpros.com/2025/07/07/audio-overview-copilot/
Turning off predictive text in Comments only
The last time I updated Microsoft Word it started utilizing predictive text while I was typing which was EXTREMELY annoying. I managed to turn it off, but for some reason it continues to do this when I'm typing in a comment. I've Googled ways to stop it from happening (i.e. disabling "modern comments," etc.) but nothing seems to work. It's very distracting! Any ideas?
Recent Blogs
- When you transfer a call, the transferee can see a Microsoft 365 Copilot summary of your discussion before they joined.Jul 07, 2025
- No more having to copy view-only files! You can now request edit access directly in your web browser.Jul 03, 2025
