Forum Widgets
Latest Discussions
Mail 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
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.
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
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!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! 😊
