HELP! Consolidating data in spreadsheet without data loss
I have a dataset that I'm trying to consolidate into unique records without losing any data. Each observation has an SSID number, and there are duplicate entries in the SSID number column. I don't want to de-dupe the records using Excel's de-duplicate, because there is information across multiple rows/columns that I would like to consolidate. Here's an example (with fake IDs to preserve confidential information): My duplicate ID is highlighted with conditional formatting. I'd like one observation for student #1234, but that preserved both the grade in Column D, and the 'yes' in Column C that appears in the second row for student #1234. Using Excel's native de-duplicate or consolidate data functions means I lose either the grade in column D or the yes in column C. Any way to do this?
Problems with Outlook / @Terra
Hello, good morning! Recently, a specific client of our company stopped receiving our emails. We have already checked the administrator panel and the emails are listed as "Delivered". We enabled the "Delivery confirmation" option in the emails to test, and it returns saying the following: Delivery to these recipients or group was completed, but the destination server did not send a delivery notification. This message returned when we sent an email to another client who also uses another provider "@openvia.com.br", but after checking, they found our emails in the spam box. The client's provider is @terra.com.br.Microsoft Planner @Mention and Comment Notification in Microsoft Teams - NEW VERSION
Hi Planner Community, Thank you for the overwhelming support for my original post last year on how to @mention someone within the Microsoft Planner community and have a message automatically emailed to them. I'm excited to share that I've completely redesigned and updated the solution to now support the new Microsoft Teams Planner and remove the issues some users found with setting up the solution. Additionally, the notification is now an adaptive card within the Microsoft Teams chat to the user you @mentioned in the Microsoft Planner comment. Screenshot example above shows a comment posted by me in a Microsoft Planner task where I’ve @mentioned David at the end of the message. Screenshot example above shows the comment posted by me in Planner being automatically sent to David (thanks to the @mention in the comment) on Microsoft Teams. Allowing David to reply in either the traditional Planner or new Teams Planner. Attached is a zip file containing the Microsoft Power Automate solution, along with a detailed walkthrough to help you set it up. Enjoy! If you download the solution, all I ask is that you please give this post a thumbs up. Thanks, everyone! Matthew Davis No More Bad Monday
Dynamic calendar with table data allowing calendar to show events duration not just the start date
I have the below dynamic calendar that shows the start date of events in a table in a calendar format. I need to show the duration of the events, so when an event lasts three days it shows in the calendar across the relevant three days. Can anyone assist in tweaking the below excel sheet to achieve this? Calendar Excel Sheet
Need help with my TEXTJOIN Formula
Hi all, I'm new to this forum and i have a question regarding this formula =TEXTVERKETTEN(", "; WAHR; FILTER( 'Training Matrix'!$I$4:$AT$4; // training names ('Internal Tracking'!$A$4:$A$85 = $A5) * // Match employee name ISTZAHL('Internal Tracking'!$E$4:$CX$85) * // Check for completion date (INDEX('Training Matrix'!$I$5:$AT$92; VERGLEICH('Internal Tracking'!$E$3; 'Training Matrix'!$B$5:$B$92; 0); VERGLEICH(TEXT('Internal Tracking'!$B$4:$B$85; "0") & "-" & TEXT('Internal Tracking'!$D$4:$D$85; "0"); 'Training Matrix'!$I$4:$AT$4; 0)) = "M"); "" )) which is in english =TEXTJOIN(", ", TRUE, FILTER( 'Training Matrix'!$I$4:$AT$4, // training names ('Internal Tracking'!$A$4:$A$85 = $A5) // Match employee name ISNUMBER('Internal Tracking'!$E$4:$CX$85) // Check for completion date (INDEX('Training Matrix'!$I$5:$AT$92, MATCH('Internal Tracking'!$E$3, 'Training Matrix'!$B$5:$B$92, 0), MATCH(TEXT('Internal Tracking'!$B$4:$B$85, "0") & "-" & TEXT('Internal Tracking'!$D$4:$D$85, "0"), 'Training Matrix'!$I$4:$AT$4, 0)) = "M"), "" )) I'm using a german excel so I'm working with the first one , regardless it gives an #WERT error which I haven't been able to fix, the components of the formula such as ISTZAHL(ISnumber) and Vergleich(Compare) works and I can't see where the mistake is . To give a context on the formula and what I'm trying to achieve : I have 3 sheets , the first one is the 'Training Matrix' .The Training Matrix is where you can see if a training according to role-section (in the header row) is mandatory (marked with a "M" ) or extra (marked with a "E").The trainings also differ according to section. As an example Engineer-SectionA has different mandatory/extra trainings than Engineer-SectionB, they are both engineers but because they are in different sections they have different trainings assigned as mandatory . In the screen shot the sections are blurred , but in the row 4 which begins from I column the format is as such "role-section". Training Name= B5:B92 , Role-Section=I4:AY4 , M/E cells=I5:AY92 In the Internal Tracking sheet you can see if an employee has completed a training.If he/she completes it , there is a date in the cell , so the cells with no date indicate that the training is NOT completed and with conditional formating you can see if the completed training is mandatory or not but this information is not relevant for the formula. Employee Name is in Column A4 , Employee Role in B4 , Section in D4, Training Names range : E3:E88 , date cells range : E4:CN85 What I'm trying to accomplish is in this sheet : Using the formula , I want to retrive the name of the completed trainings for each employee.Employee Name is in A5:A86 , role in B5:B86 and section in D5:D86 in this sheet. So for each person the completed mandatory trainings needs to be listed using the formula =TEXTVERKETTEN(", "; WAHR; FILTER( 'Training Matrix'!$I$4:$AT$4; // training names ('Internal Tracking'!$A$4:$A$85 = $A5) * // Match employee name ISTZAHL('Internal Tracking'!$E$4:$CX$85) * // Check for completion date (INDEX('Training Matrix'!$I$5:$AT$92; VERGLEICH('Internal Tracking'!$E$3; 'Training Matrix'!$B$5:$B$92; 0); VERGLEICH(TEXT('Internal Tracking'!$B$4:$B$85; "0") & "-" & TEXT('Internal Tracking'!$D$4:$D$85; "0"); 'Training Matrix'!$I$4:$AT$4; 0)) = "M"); "" )) but it doesn't work , can someone help me out ? Thanks in advance !Inconsistent print settings
Hello, We have shared printers at work that have predefined black and white printing. This setting can be temporarily changed before sending the file to print and then the entire document is printed in color (for example a word document). But excel behaves differently. When we want to print for example 4 sheets from one excel document, the color printing setting is only reflected on the first sheet, not on the others (even if we have selected that we want to print the whole document) Is this correct behavior? How to prevent this behavior? Alternatively, how to simply set the same settings for all sheets in one excel document? We use office 365. Thank you
Get a list of specific agegroup users stored on a security group
Dear Community, I wonder if it would be possible to get a list of users (stored in a security group) marked as "minor" and "not adult" using microsoft graph. Once I get the members of the group (using Get-MgGroupMember -GroupId XXXX), I am not sure how to retrieve only the ones with a specific agegroup property. Is that feasible? Any help would be greatly appreciated. Many thanks in advance!
