Category: Microsoft
Category Archives: Microsoft
Excel VLOOKUP with Multiple Criteria (Dynamic Price Tiers) to determine Markup Price
I have a table with four columns: Price Tier, Min, Max, % rate. I want to use a vlookup in excel to determine the appropriate % rate based on the input from the user, and then compute the markup price (dynamic price tiers).
I have tried these formulae with no success:
1. To get the price tiers, I used: LOOKUP(2,1/((H3>=H6:H17)*(H3<=I6:I17)),G6:G17)
2. To get the % rate, I used: =LOOKUP(I3,tiers,customers)
I would appreciate any help.
Also, how do I use mins and maxes in excel? I don’t mean minimum and maximum. It puzzles me that I can’t even get a hint about it in excel.
Again, I would appreciate your help in solving this problem.
I have a table with four columns: Price Tier, Min, Max, % rate. I want to use a vlookup in excel to determine the appropriate % rate based on the input from the user, and then compute the markup price (dynamic price tiers). I have tried these formulae with no success: 1. To get the price tiers, I used: LOOKUP(2,1/((H3>=H6:H17)*(H3<=I6:I17)),G6:G17)2. To get the % rate, I used: =LOOKUP(I3,tiers,customers) I would appreciate any help. Also, how do I use mins and maxes in excel? I don’t mean minimum and maximum. It puzzles me that I can’t even get a hint about it in excel. Again, I would appreciate your help in solving this problem. Read More
Access crashing directly on start
Hello,
since this morning Access is always crashing directly on start without any comment.
I had trouble since some month that Access was crashing during development several times a day. But i could accept that, as i always save the Db under different Version number, after some changes.
But the problem now is that i even can not start Access directly from the Start-menue, without selecting a specific file.
Any idea how i can fix this issue?
Hello,since this morning Access is always crashing directly on start without any comment.I had trouble since some month that Access was crashing during development several times a day. But i could accept that, as i always save the Db under different Version number, after some changes.But the problem now is that i even can not start Access directly from the Start-menue, without selecting a specific file. Any idea how i can fix this issue? Read More
Make a contact that we can call by phone number.
Hello
Please i need your help on this issue.
i have added a contact in our tenant, and i want it to default to dial the phone number if i place a call from Teams to this contact. Now it tries to call by e-mail address.
Hello Please i need your help on this issue. i have added a contact in our tenant, and i want it to default to dial the phone number if i place a call from Teams to this contact. Now it tries to call by e-mail address. Read More
How Can I Resolve Error PS038 in Quick-Books?
I’m encountering Error PS038 in Quick-Books when trying to update. It’s causing a lot of disruption in my workflow. What could be causing this error, and what steps can I take to troubleshoot and resolve it?
I’m encountering Error PS038 in Quick-Books when trying to update. It’s causing a lot of disruption in my workflow. What could be causing this error, and what steps can I take to troubleshoot and resolve it? Read More
PivotTable issue with duplicating field
Hello,
So a colleague of mine has set-up a pivot table for a consultation, with the entries of agree and disagree (and not answered). They’ve drawn this from imported data from a website we use for consultations.
They’ve added three additional responses, that fall under the “agree” category, however when they generated the pivot table, it’s generating a separate row for “Agree”. So say there are 15 agrees, 14 disagrees, 4 no responses and 3 agrees.
Is there a way to roll these 3 extraneous agrees into the larger set of agrees? I have a vague sense that it requires refreshing the “table” based on when I had a similar issue, but I can’t remember exactly sorry.
Thank you.
Hello, So a colleague of mine has set-up a pivot table for a consultation, with the entries of agree and disagree (and not answered). They’ve drawn this from imported data from a website we use for consultations. They’ve added three additional responses, that fall under the “agree” category, however when they generated the pivot table, it’s generating a separate row for “Agree”. So say there are 15 agrees, 14 disagrees, 4 no responses and 3 agrees. Is there a way to roll these 3 extraneous agrees into the larger set of agrees? I have a vague sense that it requires refreshing the “table” based on when I had a similar issue, but I can’t remember exactly sorry. Thank you. Read More
How do I contact Quick-Books Enterprise support number?
I’m experiencing issues with my Quick-Books Enterprise software and need to contact support. What is the Quick-Books Enterprise support number, and are there any troubleshooting steps I can try before reaching out to them?
I’m experiencing issues with my Quick-Books Enterprise software and need to contact support. What is the Quick-Books Enterprise support number, and are there any troubleshooting steps I can try before reaching out to them? Read More
File on SharePoint via teams app or shortcut is always locked for editing
Hello
Please i need your help on this issue.
We have setup Teams sharing for 2 @ users and synced to explorer – whenever i try open an excel file that has been closed for 30 mins it says its locked for editing and read only option is there
Hello Please i need your help on this issue. We have setup Teams sharing for 2 @ users and synced to explorer – whenever i try open an excel file that has been closed for 30 mins it says its locked for editing and read only option is there Read More
Exchange Upgrade Support
Dear Team,
Regarding the Exchange Server 2019 upgrade from 2016 versions, seeking confirmation on clarification on the best practices for migrating from 2016 to 2019 with the following setup.
We have Exchange server 2016 DAG with 2 servers and it has been configured with the hybrid setup. 2000 mailboxes already migrated and around 1500 mailboxes are in On-prem. We would like to migrate our existing Exchange Server environment to 2019 and The goal is to continue using the exchange infrastructure for a couple more years.Also, we are planning to deploy a load balancer in the primary site.As per our BCDR planning, the new environment will include a third DAG server in the DR site, with a decision pending on whether to extend to a fourth node. The load balancer will be implemented at the primary site only, not the DR site.
Dear Team, Regarding the Exchange Server 2019 upgrade from 2016 versions, seeking confirmation on clarification on the best practices for migrating from 2016 to 2019 with the following setup.We have Exchange server 2016 DAG with 2 servers and it has been configured with the hybrid setup. 2000 mailboxes already migrated and around 1500 mailboxes are in On-prem. We would like to migrate our existing Exchange Server environment to 2019 and The goal is to continue using the exchange infrastructure for a couple more years.Also, we are planning to deploy a load balancer in the primary site.As per our BCDR planning, the new environment will include a third DAG server in the DR site, with a decision pending on whether to extend to a fourth node. The load balancer will be implemented at the primary site only, not the DR site. Read More
Multiple forests with same local domain
Hello,
Before we drop this idea completely just wanted to check with the community if this setup is even possible. We have our main local domain which is configured with AD Connect and all devices are hybrid joined. This works well. Additionally, we have a multiple small separate domains, no trusts or connections between them and our main domain. User account and hostnames are unique and exist in single domain only. We wanted to use AD Connect to synchronize all of them into single Azure tenant and make all devices hybrid joined and enrolled into Intune. From what I understand, in this scenario you can only have one AD Connect server. This obstacle we can overcome. All separate domains have exactly same forest name in .local, let’s say example.local. I know .local domain is not allowed, so we can create additional UPN to match our main office UPN. But is it possible to add multiple, separate forests with same UPN suffix into Connector? Should I create unique UPN suffixes for each? A lot of users from those separate domain already have cloud only account because they use Exchange Online mailbox. Hope this is clear enough to give some answers.
Hello, Before we drop this idea completely just wanted to check with the community if this setup is even possible. We have our main local domain which is configured with AD Connect and all devices are hybrid joined. This works well. Additionally, we have a multiple small separate domains, no trusts or connections between them and our main domain. User account and hostnames are unique and exist in single domain only. We wanted to use AD Connect to synchronize all of them into single Azure tenant and make all devices hybrid joined and enrolled into Intune. From what I understand, in this scenario you can only have one AD Connect server. This obstacle we can overcome. All separate domains have exactly same forest name in .local, let’s say example.local. I know .local domain is not allowed, so we can create additional UPN to match our main office UPN. But is it possible to add multiple, separate forests with same UPN suffix into Connector? Should I create unique UPN suffixes for each? A lot of users from those separate domain already have cloud only account because they use Exchange Online mailbox. Hope this is clear enough to give some answers. Read More
Outgoing mail is considered spam
Hi,
I have a user in our tenant who sends emails to multiple people at one time. The maximum number is 200 recipients at a time per day. This concerns 1 email with, for example, 200 recipients. Now, after the email has been sent, this user is marked as Spam and the account is blocked. When I then look at the reason, it says Domain reputation.
The user also remains within Microsoft’s sent limits.
How can I find out or where can I within O365 what the exact reason is why this user is blocked and the email is considered spam.
There are several users who do this and do not receive any notifications.
Can someone help me with this?
Kind regards,
Jacob
Hi, I have a user in our tenant who sends emails to multiple people at one time. The maximum number is 200 recipients at a time per day. This concerns 1 email with, for example, 200 recipients. Now, after the email has been sent, this user is marked as Spam and the account is blocked. When I then look at the reason, it says Domain reputation. The user also remains within Microsoft’s sent limits.How can I find out or where can I within O365 what the exact reason is why this user is blocked and the email is considered spam.There are several users who do this and do not receive any notifications.Can someone help me with this? Kind regards,Jacob Read More
Enrolling devices over mobile network (QR Code)
Hi All,
I have been asked the question , can an Android device be enrolled over mobile networks if WiFi wasn’t available. Using a QR code scan.
I have done some Googling and the main answer is to amend the QR code to enable enrolment over mobile networks, but the post’s are from 2020.
Has a method been added to Intune to allow this kind of enrolment.?
I have tried on a device with an active sim card in but get stuck at the Wifi select screen.
Any help appreciated.
Hi All, I have been asked the question , can an Android device be enrolled over mobile networks if WiFi wasn’t available. Using a QR code scan. I have done some Googling and the main answer is to amend the QR code to enable enrolment over mobile networks, but the post’s are from 2020. Has a method been added to Intune to allow this kind of enrolment.? I have tried on a device with an active sim card in but get stuck at the Wifi select screen. Any help appreciated. Read More
Best way to download youtube playlist to mp3 on my computer?
I am very interested in a YouTube playlists, which contains dozens of my favorite songs. I hope I could download the whole YouTube playlist to MP3 so I can listen them on my Windows 11 PC and my car.
I need some advice on how to download YouTube playlist to MP3 on my computer. I have found some tools and methods online, but I’m not sure which ones are reliable and safe to use. Does anyone have any recommendations for software or websites that can do this effectively without any risk of malware or poor quality? I’m open to both free and paid options as long as they work well.Thank you
I am very interested in a YouTube playlists, which contains dozens of my favorite songs. I hope I could download the whole YouTube playlist to MP3 so I can listen them on my Windows 11 PC and my car. I need some advice on how to download YouTube playlist to MP3 on my computer. I have found some tools and methods online, but I’m not sure which ones are reliable and safe to use. Does anyone have any recommendations for software or websites that can do this effectively without any risk of malware or poor quality? I’m open to both free and paid options as long as they work well.Thank you Read More
Booking showing 1hr earlier when booked on the day
Hello All,
I am having a massive issue with our booking calendar that we use for volunteers. If they book a slot on the day, the calendar brings the slots an hour earlier. This isn’t for the whole day but for the first 12hrs or so. I have looked at the time zones and staff working location time zones but all are the same at UTC+00:00 (Dublin, Lisbon etc) and set to always use business hours, lead time is set to 0 and max as 365 days. I cant see what might be bringing the time an hour earlier when volunteers apply.
Thanks in advance
Hello All, I am having a massive issue with our booking calendar that we use for volunteers. If they book a slot on the day, the calendar brings the slots an hour earlier. This isn’t for the whole day but for the first 12hrs or so. I have looked at the time zones and staff working location time zones but all are the same at UTC+00:00 (Dublin, Lisbon etc) and set to always use business hours, lead time is set to 0 and max as 365 days. I cant see what might be bringing the time an hour earlier when volunteers apply. Thanks in advance Read More
Penalty when cancelling an Azure Reserved Instance PAYG subscription
Dear community,
We are an Indirect Provider in CSP located in Greece, and we have the following requests from one of our partners:
1. Could you kindly advise if our partners can cancel all the existing RIs with immediate effect?
2.If the answer on point 1 yes and they can do so, then will there be a cancellation fee/penalty upon cancelling the Reserved Instances?
Thank you in advance for your prompt response as we need to sort it the soonest!
Best regards,
Dear community, We are an Indirect Provider in CSP located in Greece, and we have the following requests from one of our partners: 1. Could you kindly advise if our partners can cancel all the existing RIs with immediate effect?2.If the answer on point 1 yes and they can do so, then will there be a cancellation fee/penalty upon cancelling the Reserved Instances? Thank you in advance for your prompt response as we need to sort it the soonest! Best regards, Read More
What is the Quick-Books Desktop Support Number and How Do I Contact Them?
I have been experiencing various issues with my Quick-Books Desktop software, including update errors and performance problems. I’ve heard that contacting Q.B support can help resolve these issues quickly, but I’m not sure how to get in touch with them. What is the Q.B Desktop support number, and how do I contact them for assistance?
I have been experiencing various issues with my Quick-Books Desktop software, including update errors and performance problems. I’ve heard that contacting Q.B support can help resolve these issues quickly, but I’m not sure how to get in touch with them. What is the Q.B Desktop support number, and how do I contact them for assistance? Read More
I would like to identify companies that leverage all of the features that 365 offers
After working at several startups, I have reached a point where I can no longer work in environments that do not leverage the amazing features of the Microsoft 365 platform for collaboration among all employees.
I am currently running a one-man shop and thoroughly enjoy using almost all the services that Microsoft 365 offers. Granted I a have been working as the administrator and do not have complex setups, but I do see the power of 365 and I am a big believer in the One Drive / Sharepoint framework progress. What I am looking for is a company that already has the practices in place for 365 and would like to see if anyone has recommendations for companies. My concern is joining a new job and being presented with a disjointed set of productivity tools instead of using streamlined solutions like Slack.
Is there an award ceremony or a list of companies that are consistently recognized as the most efficient users of Microsoft 365?
I would rather not settle for companies that use Slack, Airtable, or Monday.com when Microsoft’s tools already have better tools for seamless collaboration.
After working at several startups, I have reached a point where I can no longer work in environments that do not leverage the amazing features of the Microsoft 365 platform for collaboration among all employees.I am currently running a one-man shop and thoroughly enjoy using almost all the services that Microsoft 365 offers. Granted I a have been working as the administrator and do not have complex setups, but I do see the power of 365 and I am a big believer in the One Drive / Sharepoint framework progress. What I am looking for is a company that already has the practices in place for 365 and would like to see if anyone has recommendations for companies. My concern is joining a new job and being presented with a disjointed set of productivity tools instead of using streamlined solutions like Slack. Is there an award ceremony or a list of companies that are consistently recognized as the most efficient users of Microsoft 365?I would rather not settle for companies that use Slack, Airtable, or Monday.com when Microsoft’s tools already have better tools for seamless collaboration. Read More
How Can I Create Bootable USB for Mac OS X Mountain Lion?
My dad’s old iMac 2007 was broken and replaced with a new hard drive. This Mac comes with Mac OS X Mountain Lion when it was shipped. How can I create a bootable Mountain Lion USB on a Windows PC so I can reinstall OS X Mountain Lion on this Mac.
Here are the steps I’ve taken so far:
Downloaded the Mac OS X Mountain Lion installer from the Mac App Store.Prepared a USB drive (at least 8GB) and formatted it using Disk Utility with Mac OS Extended (Journaled) format.Tried using the terminal command ‘createinstallmedia’ but it seems to be unsupported for Mountain Lion.
I would appreciate detailed steps or any tools you recommend for creating a Mac OS X bootable USB drive on a Windows PC or Mac.
My dad’s old iMac 2007 was broken and replaced with a new hard drive. This Mac comes with Mac OS X Mountain Lion when it was shipped. How can I create a bootable Mountain Lion USB on a Windows PC so I can reinstall OS X Mountain Lion on this Mac. Here are the steps I’ve taken so far: Downloaded the Mac OS X Mountain Lion installer from the Mac App Store.Prepared a USB drive (at least 8GB) and formatted it using Disk Utility with Mac OS Extended (Journaled) format.Tried using the terminal command ‘createinstallmedia’ but it seems to be unsupported for Mountain Lion.I would appreciate detailed steps or any tools you recommend for creating a Mac OS X bootable USB drive on a Windows PC or Mac. Read More
Tracking documents folder linked to onedrives
Hi
I’m just starting out in SharePoint admin. I am after a way of being able to track down who has their OneDrive accounts directly linked or are sync’ing with Document Library folders on SharePoint sites. Ideally I need a global report as I work for a school and we have lots of different departments.
We are using cloud based SharePoint (using through Edge) with OneDrive clients sat on Win11 pro boxes.
TIA
Matt
Hi I’m just starting out in SharePoint admin. I am after a way of being able to track down who has their OneDrive accounts directly linked or are sync’ing with Document Library folders on SharePoint sites. Ideally I need a global report as I work for a school and we have lots of different departments. We are using cloud based SharePoint (using through Edge) with OneDrive clients sat on Win11 pro boxes. TIAMatt Read More
Seeking Help: How to convert YouTube to MP3 on Windows 11?
Hello everyone,
I’ve been on a quest to curate my perfect offline playlist, and I’ve found some fantastic tunes on YouTube that I’d love to listen to on the go. The catch? I’m running Windows 11 and could use some guidance on the easiest and most reliable ways to convert these videos into crisp, high-quality MP3s.
Question Time:
Are there any fellow Windows 11 users out there who have mastered the art of turning those YouTube music videos into MP3 files? I’m looking for software recommendations or perhaps some web-based solutions that work seamlessly with my OS. Ideally, something user-friendly, safe, and won’t compromise the audio quality.
Hello everyone, I’ve been on a quest to curate my perfect offline playlist, and I’ve found some fantastic tunes on YouTube that I’d love to listen to on the go. The catch? I’m running Windows 11 and could use some guidance on the easiest and most reliable ways to convert these videos into crisp, high-quality MP3s. Question Time:Are there any fellow Windows 11 users out there who have mastered the art of turning those YouTube music videos into MP3 files? I’m looking for software recommendations or perhaps some web-based solutions that work seamlessly with my OS. Ideally, something user-friendly, safe, and won’t compromise the audio quality. Read More
Mail Flow Loop prevention
We are setting up an environment where we have a shared smtp between 2 exchange organization for migration.
So on each organization we’ll configure a send connector for the SMTP domain.com ( internal relay )
To prevent a mail loop for non existent recipient I think a mail flow rule must be created, and I saw some articles that I couldn’t find anymore, to check for the X-headers.
Can anyone help me providing some examples ?
thanks
We are setting up an environment where we have a shared smtp between 2 exchange organization for migration.So on each organization we’ll configure a send connector for the SMTP domain.com ( internal relay ) To prevent a mail loop for non existent recipient I think a mail flow rule must be created, and I saw some articles that I couldn’t find anymore, to check for the X-headers.Can anyone help me providing some examples ?thanks Read More