Recent Discussions
Grouping
Is there a way to group by just the column with the data in it? I have 20k+ rows of data. I need to label in Col A based upon the group in Col AK. I have already sorted the data so that the top row of each group is the one I need to label. I just need a way to see only the first row of each group. I need to see the rows with pink highlight only.
Cannot contact support in MS Access / where to file bug report
Hi, I want to file a bug report. I click on the main menu "help" / "contact support". A window appears saying "This didn't work. Please check your network settings". The network settings are ok. There is no other option to send feedback in the application. How can I file a bug report? Best regardsMail Merge to Email Addresses
Need some help. I am using Excel as a data source and created word document templets for mail merging. With in the data source I have for columns for entering email addresses. Personal Email address Work Email Address Supervisor Email Address Section Email Address Combined Email Address When I need to send an email to an individual that also needs to go out to all the emails, I have joined the email addresses together using the following formula and have the combined email addresses in a column called Combined. =LET(email,TEXTJOIN("; ",TRUE,T3:U3,AS3:AT3),IF(email="","",HYPERLINK("mailto:"&email,email))) This works with no issues and am able to click on a combined email line and it launches the email program and drops the line of EMAIL ADDRESSES into the email TO: location. The issue I need help with, if possible, is the interaction with the combined email and word mail merge. When I try to do the mail merge and select the Combined Email Address column, word gives me an error, "Microsoft Outlook does not recognize " the list of combined email addresses". Is there a way for outlook to recognize the combined email addresses during the merge? Any help would be greatly appreciated. Carl
Conditional Formatting Help
Hi Everyone, I have been working on this problem for weeks and still can not find an answer: I am creating a spreadsheet which involves completing specific tasks by different members. I have formatted the cells to change colors based on the answer of another cell. basically as a reminder to complete it. Now here is my problem, Cell AO7 is under the title project completed. what I am wanting is for that cell to be Red if any of the cells in data range D8:N66 are red. that way we know the project still has an item that needs to be completed. Hope I explained that right. Also, rows 8-66, will be copied and pasted to create the tasks for other projects
MS Access Email Report
Hi I have a Form that I can email as a report. There is an email address on the report that is automatically used as the 'sent to' address within Outlook. Is it possible to lookup a cc email address that is not on the form and add this to outlook also. I am using linked Sharepoint tables for some of the dropdown inputs on the form, and all data is saved to Sharepoint. I am using the embedded macro function as below. Thanks
Unable to Connect my Hotmail Account to Outlook for Mac
I have an M3 MacBook Pro MAX running Parallels Desktop to give me Windows 11. Historically, I have been able to run Outlook on MacOS and Windows without any problems. However, now I can'tadd my Hotmail account to Outfor Mac v16.93. I have removed Outlook and reinstalled it. I have cleared the application data. I also tried to raise a support ticket, but it won't connect to the Live Chat agent. Contact Support - Outlook for Mac OneCustomer | Chat Support We are unable to load chat at this time. Please try again later. When I try to add my Hotmail account back in, I get the following message after accepting the Authenticator challenge. Outlook.com Connecting to Outlook.com. An authentication error occurred while configuring account. Try Again Connecting to Outlook via a web browser works; Outlook on Windows also works. Any recommendations on how I can add Hotmail back into Outlook for Mac? Many thanks, David
Power Query Formula to Calculate Current Count From Previous Count per Name using Date
Hi everyone! I have a dataset with the following columns: Point Name, Pump Count, Record Date, and Index. My goal is to create a calculated column in Power Query that computes the following for each Point Name, based on the Record Date: If (Current Pump Count - Previous Pump Count) >= 0, apply: (Current Pump Count - Previous Pump Count) * 0.3 If the result is negative, use this formula instead: ((1,000,000 - Current Pump Count) + Previous Pump Count) * 0.3 Problem: I tried duplicating the Pump Count column and creating a custom column for the previous count using Table.Buffer, but it didn’t align correctly by Point Name and Record Date. Indices may not be sequential, so referencing the immediate index won’t work. I considered grouping by Point Name and sorting by Record Date to dynamically calculate the Previous Pump Count, but was unsure. I tried this formula for Previous Pump Count but it doesn’t align correctly for Point Name or handle skipped indices. My Current Formula: Table.Buffer(#"Duplicated Column3")[Pump Cycle Count]{[Index] - 1} otherwise null Desired Process: Group by Point Name. Sort within each group by Record Date Use the formula to compute the difference: If (Current Pump Count - Previous Pump Count) >= 0, apply: (Current Pump Count - Previous Pump Count) * 0.3. Else, apply: ((1,000,000 - Current Pump Count) + Previous Pump Count) * 0.3. How can I implement this in Power Query, ensuring it dynamically references the Previous Pump Count for the same Point Name, even if indices are skipped or Record Dates are close?I don't understand this logic with StockHistory function...
I don't understand this.... I will show my question step by step: 1. =STOCKHISTORY(E4,TODAY()-10,TODAY(),,0,1) Gives me an array. 2. I use ROWS and INDEX to get the last number of the array. =INDEX(STOCKHISTORY(E4,TODAY()-10,TODAY(),,0,1),ROWS(STOCKHISTORY(E4,TODAY()-10,TODAY(),,0,1))) gives me the last number of the array. 3. I change "E4" to "E4#" =INDEX(STOCKHISTORY(E4#,TODAY()-10,TODAY(),,0,1),ROWS(STOCKHISTORY(E4#,TODAY()-10,TODAY(),,0,1))) Gives me the 0.67....which is the price of "8zz" the last one on E4#. I was expecting to get the last number of each and every StockHistory array of every elements in E4#... Instead, I only get the "first" number of the last element in E4#. I don't understand the logic of this function....Can anybody explain this strange behavior? Thank you very much!
Excel Online App Request Was Taking Too Long -open this in the desktop app
I have a fairly large workbook that has been working absolutely no problem up until this past weekend, where it will not open in the Excel online app. It opens on the desktop app just fine. Nothing in the workbook has changed, in fact we have a back up from several months ago and that doesnt open up either. We have tried on different computers, even different M365 accounts. Done a huge amount of trouble shooting, but the fact the backup file doesnt open either, weve concluded its some change in the Excel online apps capabilities. I've looked for updates that might have happened to the online app over the weekend but can't find anything published by Microsoft that is relevant. Would really appreciate help please - it's an essential part of our business. Thanks!Library conflict
Hi In unity console I have this "red" error: "......We can't assign a new GUID because the asset is in an immutable folder. The asset will be ignored" This happened after I tried to update the library Microsoft Mesh Toolkit, but after encountering a series of errors that I didn't want to investigate further, I reverted to version 5.2402.240 I tried deleting the corresponding meta file to force a Packagecache refresh, but the result remains the same. Does anyone have any suggestions?Help Excel
Hello, Here is my problem: I have a list of price (attached in the message). And then a list of customers to invoice. For each customers, I have the Code they belong to and then a number of user which may vary from one customer to another. Which formula could I use to search for the Price depending on the Code and then the range of Users please? Thank you in advance for your help,
VBA requirement
Hi everyone, I’ve written a VBA script to dynamically retrieve and display data based on user interactions in an Excel workbook. The script triggers when I select a cell in Sheet1 (which contains product names) and performs the following tasks: Searches for the selected product in Sheet2, retrieves its category and price. Looks for matches in Sheet3 based on the category or price. Copies matching rows from Sheet3 into Sheet4, grouping results by category, and organizes them in separate column groups (e.g., Columns A-J for one category, K-T for the next, etc.). Additionally, the script clears previous results in Sheet4 and displays a message if no matches are found. What I Need Help With: Optimizing the script to handle larger datasets more efficiently. Suggestions for improving readability and maintainability of the code. Advice on handling edge cases or potential bugs I might have missed. Any recommendations to enhance the functionality or logic. I’d really appreciate your feedback and suggestions! Let me know if you need more details about the logic or the structure of my workbook. Thanks in advance! 😊Improve performance of VBA macro
Hi, What can I do to improve the performance of the attached macro? The different sections of the code ('LOOP THROUGH SUBJECTS FOR SCREENING TEST CASE', 'LOOP THROUGH SUBJECTS FOR C1D1 TEST CASE', 'LOOP THROUGH SUBJECTS FOR C1D8 TEST CASE', 'LOOP THROUGH SUBJECTS FOR C2D1 TEST CASE' and 'LOOP THROUGH SUBJECTS FOR END OF TREATMENT TEST CASE') are all a little different in nature. So it's not possible to combine them in one loop. Thank you for your help! Both the code of the macro, and the spreadsheet on which I'm running the macro, are attached.The Confusing Renaming of Microsoft 365 Copilot
Microsoft loves branding exercises. At least, that can be the only reason why the Microsoft 365 Copilot rename is happening. I can think of no other reason why Microsoft would seek to confuse its customers by applying the Microsoft 365 moniker to an app that can’t access Microsoft 365 data, unless of course people pay to use Copilot agents. It’s all very confusing. https://office365itpros.com/2024/12/20/microsoft-365-copilot-rename/Word hiding comments on text with tracked changes
This is an extremely frustrating bug that I've been experiencing for maybe six months or more in Microsoft 365. If I add a comment to text that I've changed via track changes (e.g. I've bolded it), the comment will be irretrievably hidden, though the commented-on text will still he highlighted, suggesting there is a comment there; it just can't be seen. This doesn't happen with all changes, though font changes seem to be the biggest culprit. It's annoying when I forget it's there, take a couple minutes writing a comment explaining changes for a client, only to see it disappear and not be able to even retrieve the text I wrote. I hope there's a fix coming for this soon?VBA Code: ensuring users fill out specific cells
Hi all, I'm looking for some help with the following: My team has a excel spreadsheet with a table in it. This spreadsheet gets passed around different users as they each need to fill in a row with their data. The problem is, not all users are filling in the "mandatory" columns. So, when I open up the document after everyone has supposedly filled it in, I see blanks where I should see data. I have used CoPilot to help write a VBA code that basically stops the document from being closed or saved until a row in the table has been filled in: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) If Not IsTableComplete() Then MsgBox "You must complete at least one row in the table before saving.", vbCritical, "Incomplete Data" Cancel = True End If End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) If Not IsTableComplete() Then MsgBox "You must complete at least one row in the table before closing.", vbCritical, "Incomplete Data" Cancel = True End If End Sub Function IsTableComplete() As Boolean Dim ws As Worksheet Dim tbl As ListObject Dim row As ListRow Dim isComplete As Boolean ' Set the worksheet and table name (update "Sheet1" and "Table1" to match your spreadsheet) Set ws = ThisWorkbook.Worksheets("Sheet2") Set tbl = ws.ListObjects("Table14") isComplete = False ' Default to incomplete ' Check if any row is fully filled out For Each row In tbl.ListRows Dim allFilled As Boolean allFilled = True ' Assume the row is complete Dim cell As Range For Each cell In row.Range If isEmpty(cell.Value) Then allFilled = False Exit For End If Next cell If allFilled Then isComplete = True Exit For End If Next row IsTableComplete = isComplete End Function However, when I fill in the first row, save and close the document, upon re-opening it, the warning messages disappear and I can save and close the document. I need the code to reset itself each time a user opens the document. So that it checks when its been newly opened for the next blank row, if that has not been filled in then the user should not be able to save or close the document until it is. Any help on this would be much appreciated :) The 'practice' table looks like this:
Recent Blogs
- Create linked forms directly from an Excel workbook to sync responses automatically and streamline data collection.Dec 20, 2024
- Aswe are evolving theMicrosoft 365 app to enable more AI first experiences, we are retiring the 'My Day' feature (shown in the Figure 1) on the Microsoft 365 appfor the enterprise users.This chan...Dec 20, 2024
