Recent Discussions
Need assistance to correct a formula
I am using the following formula to calculate weekly hours. I want to change it to calculate the hours with the starting on Monday going to Sunday and display the result in column G on the Sunday. For example - calculate totals from Monday Jan 6 to Sunday Jan 12, inclusive. Thanks in advance for your help. =IF(WEEKDAY(B6)=7, IF(SUMIFS(D:D,B:B, ">="&B6-6,B:B, "<="&B6)>0, SUMIFS(D:D,B:B, ">="&B6-6,B:B, "<="&B6), ""), "") A B C D E F G 1 Date Hours Purchases Rate Daily Cost Hrs / wk 2 1-Jan Wed 5 $20.00 $100.00 3 2-Jan Thu 5 $0.00 4 3-Jan Fri $20.00 5 4-Jan Sat $20.00 10.00 6 5-Jan Sun 7 $20.00 $140.00 7 6-Jan Mon $20.00 8 7-Jan Tue $20.00 9 8-Jan Wed $20.00 10 9-Jan Thu $20.00 11 10-Jan Fri $20.00 12 11-Jan Sat $20.00 7.00 13 12-Jan Sun 3 $20.00 $60.00
Move repeating columns into rows
Hello guys, I have a set of data that looks like this: Name Hours Date Hours Date Hours Date John 3 1-Jan 4 5-Jan Ann 4 4-Jan 2 8-Jan 2 9-Jan Each Hours data cell have a comment in it, and I'm trying to turn it into something like this: Name Hours Date John 3 1-Jan John 4 5-Jan Ann 4 4-Jan Ann 2 8-Jan Ann 2 9-Jan Is there a way for me to do that while retaining all the comments in each Hours data cell? I'm using Excel 2016. Best Regards, John
Calculate hours using pivot table
Hi, Im making a personell planning sheet and I want to calculute the hours each teacher is teaching using a pivot table. My data is formatted in 2 tables like this (simplified): Lesson Hours Teacher 1 Teacher 2 Lesson 1 2 Paul Lesson 2 3 Pete Lesson 3 2 Paul Pete Teacher Max working hours Paul 10 Pete 15 Now its easy to create an overview of how many hours each teacher is teaching with one teacher collumn. But it need to calculate the hours based on 2 collumns like this: Paul -> Lesson 1 + Lesson 3 = 4 hours Pete -> Lesson 2 + Lesson 3 = 5 hours Then the next step is to use a metric or KPI to calculate if the teacher is exceeding their max working hours. I hope someone can help me out with this... Thanks!
Google workspace migration - Automatic doesn't download the JSON while creating the migration endpoi
I recently came across an issue where the google workspace migration wasn't downloading the Json file. After a lot of struggle, I figured out that google by default blocks service account key creation. To resolve this, follow the below mentioned steps 1) login to https://console.cloud.google.com/iam-admin and select the root org 2) Add Organisation Policy Administrator role 3) Click on Organization policies and then search for "Disable service account key creation" and set the enforcement to OFF. 4) Now you should be able to download the JSON.Google Workspace to microsoft 365 migration
When we are migrating from Google workspace to Microsoft 365 using Microsoft automated migration method, what are the chances of emails getting duplicated if in Google an email has multiple labels tagged. And also, what's the limit of user data we can migrate per day and how many concurrent users we can migrate?How to migrate a business from Google Workspace to Microsoft 365? Users email, docs, sheets, Teams
I was tasked with my company of about 10 people to migrate our current workspace in Google to Microsoft 365. I was given a list of Microsoft One Drive prepaid keys to do this and I have set up my account but not too sure of the next step as there is a lot of articles and I'm unsure which is the most updated and seamless way to approach this. I would like to transfer emails, folders, docs, and sheets from Google to One Drive as well as set up Teams so we are fully integrated in the Microsoft suite! I'm not too sure of what is necessary as I'm only familiar with Google Workspace and Slack. So far I have the prepaid keys list but how can I start migrating over? Thank you!
Migrating from Google Workspace with Multiple Domains
I am interested in switching from Google Workspace to Microsoft 365 for Business. For context, I just use this personally, but enjoy the custom email and control over my account. I want to switch over because the only product that I use is Gmail, and pay for an additional Microsoft 365 subscription. While I won't be saving any money, or the savings will be negligible, it would be nice to have everything in one ecosystem. I've looked over how to migrate just one domain, and that seems fairly straight forward. However, I am wondering how feasible it would be to transfer multiple domains, and to switch my primary domain. Below is the structure of my current Google Workspace domains: - domain1.com | This is used as my primary domain that I log into. Also serves as my primary email. - domain2.com | Used as an additional email alias for different purposes. Not used for logging in. - domain3.com | Used as an additional email alias for different purposes. Not used for logging in. If I wanted to keep domain1.com as my primary domain, I assume that I would do the standard migration and then add domain2.com and domain3.com as additional email aliases. However, I want to switch my primary domain in Microsoft 365 to domain2.com. Is there any way to migrate emails from Google Workspace that's on domain1.com --> domain2.com via Microsoft 365 and make domain2.com the primary domain? I know that this is a lot, so please ask for clarification if needed. Thanks!
Simply cannot delete a section break. It is impossible. Cannot be done. Please prove me wrong.
So I was introduced to section breaks as a means of getting page numbering up-to-spec for book I've written (roman. numerals in the front material, arabic numerals in the book itself). I'm using the latest version of Word (16.8?) on Mac. To my horror, I've found that it is impossible to delete section breaks once they're in my document. I have spend an entire day in Google on this subject, and every single suggestion fails. So I have enabled showing markup, so I can see page breaks, section breaks, paragraphs I cannot select a section break. Word will not allow that. So I can't select and delete it. I cannot put the cursor after a section break and then hit the delete button as many suggest. Word will not allow the cursor to be placed after a section break. Putting the cursor before the section break, as other articles recommend, is just wrong. All you're doing there is deleting text before the section break. Why is this so hard? I've lost a whole day on something that should be simple. In the screenshot from my document below, The section break simply cannot be touched.
tenant completely unreachable after update PLAID number on partner portal
Hi, i'm a reseller in Italy. I have a partnership with a local distributor to resell Office 365 product from many years. On the license side (my panel at vendor) i see my license available yet, like other customers. In these days we have changed the PLAID as requested to enable again our partnership. I've opened the ticket as suggested and after that we have lost completeley the access with any admin of our domain (@noorduffici.com and onmicrosoft.com) I can't login even in the partner portal of microsoft that reply with ( the mail doesn't exists) I've tried to call any number of support but anytime I go on with a virtual caller without a solution . Someone could hel about this issue ? The domain is not corrupted because i've access and i change the MX record to work temporaly with mail NOT microsoft.How to Report DLP Alerts
MC1169572 announces that administrators can add classifications to DLP alerts to help with reporting. But how do you report DLP alerts? As it turns out, it’s relatively easy to retrieve DLP alerts via the Microsoft Graph Security API, and using the Get-MgSecurityAlertV2 cmdlet from the Microsoft Graph PowerShell SDK makes it even easier to find and report the data. https://office365itpros.com/2025/12/29/dlp-alerts-report/Playing with conditional formatting
This formatting is something I used to restructure the way I wrote formulas between 2015 and 2018. In the original I used VBA but now, as often happens, worksheet formulas used within conditional formatting are sufficient. The formula defining the condition is = DIRECTREFλ(A1) //Function to test for the presence of direct cell references DIRECTREFλ = LAMBDA(cell, IF(ISFORMULA(cell), REGEXTEST(FORMULATEXT(cell), "\b[A-Z]{1,3}\${0,1}\d{1,6}\b")) ); The original was pretty effective as a training aid to avoid the practice of relative referencing and use defined names! That said, not many followed my lead! Mind you when I posted a discussion on Chandoo it didn't meet with overwhelming support, though subsequent events in the form of spilt ranges have made my life so much easier! The post did however stimulate more discussion than I had anticipated. The A1 notation is an abomination that has no place within serious spreadsheet design -- discuss? | Chandoo.org Excel Forums - Become Awesome in ExcelHelp with changing a formula
Hi - I am using a formula to sum hours worked for a week. Currently it calculating the values beginning on Sunday to Saturday. I would like to change it to sum from Monday to Sunday and display the result in column G on the Sunday of that week. I'm hoping you can help me. TIA I am currently using the following formula. =IF(WEEKDAY(A2)=7, IF(SUMIFS(C:C,A:A, ">="&A2-6,A:A, "<="&A2)>0, SUMIFS(C:C,A:A, ">="&A2-6,A:A, "<="&A2), ""), "") A B C D E F G H 1 Date Hours Purchases Rate Daily Cost Hrs / wk 2 1-Jan Wed 2.5 $20.00 $50.00 3 2-Jan Thu 4 3-Jan Fri $20.00 5 4-Jan Sat 3 $20.00 $60.00 5.50 6 5-Jan Sun $20.00 7 6-Jan Mon $20.00 8 7-Jan Tue $20.00 9 8-Jan Wed $20.00 10 9-Jan Thu $20.00 11 10-Jan Fri $20.00 12 11-Jan Sat 3 $20.00 $60.00 3.00 13 12-Jan Sun 3 $20.00 $60.00
MS Office Word numbered list formatting style bug
There are numerous bugs related to the subject above. It has been so for several years, from Word 2010 or even earlier. It has been carried forward to the current Office 365. Paid office users need better support than this. This is the bug: The List number style. Applies number sequence from the paragraph above. I want it strart from 1. This context window will not do what it says. I have to manually set it to 1. If I reapply the style it again reverts to where it began. Request MS Office development team to take note of this and do a patch update. I know you would want to tell me to say it at the user voice. There is a bigger multi level numbered paragraph bug that I have requested numerous times on the user voice with no result.
Case 2512040040001886 - Cannot Access Account
Since the 4th of December we have been patiently waiting on MS Tech support to assist on resolving our Case with no success endless calls and endless promises with no luck. How do you proceed in using Microsoft for a Business if they don't deliver on the support. My business is taking the brunt of it. I suppose another call holding for hours and another Support person promise a solution. No other methods to log complaints as you cannot log into your Account Portal.
Recent Blogs
- Rich alt text is automatically generated when you insert an image, making your content more accessible from the get-go.Dec 22, 2025
- Powered by Microsoft 365 Copilot, Explainer offers instant summaries and explanations of text.Dec 19, 2025
