Category: Microsoft
Category Archives: Microsoft
“Soulful Serenade Exploring the Beauty of Religious Music”
Immerse yourself in the transcendent melodies of religious music. From sacred chants to uplifting hymns, discover a spiritual journey through sound that uplifts, inspires, and connects across diverse faith traditions.
Immerse yourself in the transcendent melodies of religious music. From sacred chants to uplifting hymns, discover a spiritual journey through sound that uplifts, inspires, and connects across diverse faith traditions. Read More
Have a list automatically sort to group on another page in excel
Hi, I’m looking for a solution for billing for my company. Our current system: My boss writes down her work in a notebook as she completes it (ex. Client 1 Burger King 1 4/1/24). At the end of the month, I take the notebook and sort it all into the proper client group on our cover sheet. The info on the cover sheet pulls to individual invoices that we send to our clients. I am looking to have her keep track on a spreadsheet so I dont have to type everything out for her. She tried to just input them on our cover sheet but she got too nervous about messing something up, plus she found it time consuming to try and find the right client group. She’d prefer just have a spreadsheet open and write things as she goes.
This is a simplified version of what my billing looks like:
Client 1Property# of filesDateMcdonalds454/1/2024Burger King124/5/2024 57$2,565Client 2Property# of filesDateTaco Bell214/1/2024Subway144/9/2024Cookout254/14/2024Wendys654/5/2024 125$5,625Client 3Property# of filesDateHardys854/1/2024Carls Jr.144/16/2024Arbys134/5/2024 112$5,040
This is what she would want to be typing as she works:
ClientProperty# of FilesDateClient 1Burger King54/26/2024Client 3Hardys44/27/2024Client 2Taco Bell854/27/2024Client 2Cookout444/28/2024Client 3Arbys544/28/2024
My backup plan is just to filter by client, copy and paste to the coversheet. However, we have a few hundred clients so it would still be pretty time consuming. I want to figure out a way to have her information automatically end up in the correct client grouping. I hope I’m being clear enough. I’ve never posted here before but this is the first time I havent been able to figure something out 🙂
Thanks for your help!
Hi, I’m looking for a solution for billing for my company. Our current system: My boss writes down her work in a notebook as she completes it (ex. Client 1 Burger King 1 4/1/24). At the end of the month, I take the notebook and sort it all into the proper client group on our cover sheet. The info on the cover sheet pulls to individual invoices that we send to our clients. I am looking to have her keep track on a spreadsheet so I dont have to type everything out for her. She tried to just input them on our cover sheet but she got too nervous about messing something up, plus she found it time consuming to try and find the right client group. She’d prefer just have a spreadsheet open and write things as she goes. This is a simplified version of what my billing looks like: Client 1Property# of filesDateMcdonalds454/1/2024Burger King124/5/2024 57$2,565Client 2Property# of filesDateTaco Bell214/1/2024Subway144/9/2024Cookout254/14/2024Wendys654/5/2024 125$5,625Client 3Property# of filesDateHardys854/1/2024Carls Jr.144/16/2024Arbys134/5/2024 112$5,040 This is what she would want to be typing as she works: ClientProperty# of FilesDateClient 1Burger King54/26/2024Client 3Hardys44/27/2024Client 2Taco Bell854/27/2024Client 2Cookout444/28/2024Client 3Arbys544/28/2024 My backup plan is just to filter by client, copy and paste to the coversheet. However, we have a few hundred clients so it would still be pretty time consuming. I want to figure out a way to have her information automatically end up in the correct client grouping. I hope I’m being clear enough. I’ve never posted here before but this is the first time I havent been able to figure something out 🙂 Thanks for your help! Read More
What to Do When QuickBooks Desktop 2021 discontinued!!
For QuickBooks Desktop 2021 for Windows, add-on service access will be terminated on May 31, 2024. This covers QuickBooks Desktop Pro, Premier, Enterprise Solutions, and Accountant Edition 2021 in all of its 2021 iterations.
You won’t have access to live technical assistance or any other Intuit services that can be connected with QuickBooks Desktop if you don’t update your QuickBooks Desktop 2021 before May 31, 2024. Online bank feeds, QuickBooks Desktop Payments, and QuickBooks Desktop Payroll are all included in this. The most recent upgrades and essential security patches won’t be applied to discontinued versions.
For QuickBooks Desktop 2021 for Windows, add-on service access will be terminated on May 31, 2024. This covers QuickBooks Desktop Pro, Premier, Enterprise Solutions, and Accountant Edition 2021 in all of its 2021 iterations. You won’t have access to live technical assistance or any other Intuit services that can be connected with QuickBooks Desktop if you don’t update your QuickBooks Desktop 2021 before May 31, 2024. Online bank feeds, QuickBooks Desktop Payments, and QuickBooks Desktop Payroll are all included in this. The most recent upgrades and essential security patches won’t be applied to discontinued versions. Read More
Intune Auto Upadte policy and Manually Updating Office 365 roles back to older version
Manually updating by clicking on Microsoft 365 and Office updates roles back to older version 2309.
We have Intune Microsoft 365 Apps for Windows 10 and later setup, which should upgrade to the latest (I would think?) version you do not see the latest version instead you see one version behind.
Should this be changed from “Monthly Enterprise Channel” to “Current Channel”. What if we seem to have issues with the latest updates. Some of our IT Executives are doing a manual update, thinking that by manually updating it would fix their issues what they are seeing with Co-Pilot etc.. when using Office 365. I am not sure how this is being rolled back to 2309 from the current version.
Monthly Enterprise Channel240217328.20282April 9, 2024April 6, 2024June 11, 2024
Manually updating by clicking on Microsoft 365 and Office updates roles back to older version 2309. We have Intune Microsoft 365 Apps for Windows 10 and later setup, which should upgrade to the latest (I would think?) version you do not see the latest version instead you see one version behind. Should this be changed from “Monthly Enterprise Channel” to “Current Channel”. What if we seem to have issues with the latest updates. Some of our IT Executives are doing a manual update, thinking that by manually updating it would fix their issues what they are seeing with Co-Pilot etc.. when using Office 365. I am not sure how this is being rolled back to 2309 from the current version. Monthly Enterprise Channel240217328.20282April 9, 2024April 6, 2024June 11, 2024 Read More
how to hide the entire row on specific cell value
I am creating excel template for a report in Oracle HCM. I need to hide any row that are coming with a specific cell values. Could this be accomplished with the template?
I am creating excel template for a report in Oracle HCM. I need to hide any row that are coming with a specific cell values. Could this be accomplished with the template? Read More
I cannot open a file in the cloud . I have an account under email address removed for privacy reasons
Hi my account is opened under email address removed for privacy reasons , but, I added another email. It’s email address removed for privacy reasons. I began writing a book on this email It is called document 6 with a lot of copy added to it. I cannot open it ? It’s in onecloud area. I can see it but when i click on it it says something went wrong try again I’ve tried for two days. What can i do to retrieve the book an continue writing on it? Yes the account is current.
Hi my account is opened under email address removed for privacy reasons , but, I added another email. It’s email address removed for privacy reasons. I began writing a book on this email It is called document 6 with a lot of copy added to it. I cannot open it ? It’s in onecloud area. I can see it but when i click on it it says something went wrong try again I’ve tried for two days. What can i do to retrieve the book an continue writing on it? Yes the account is current. Read More
‘Azure NPS Extension for Azure MFA’ licensing
We have interest in installing the Azure NPS extension for Azure MFA to protect our on premise remote access VPN solution. This VPN solution is a simple firewall that provides remote access (client) VPN to our users and is used in combination with our local Win2019 Network Policy Server which acts as radius to enable the users to authenticate with their AD credentials. Those AD credentials are also synced from our local AD to Azure AD Free using Azure AD connect.
I’m trying to determine if I need extra licensing for the extension. The documentation says: “The NPS Extension for Microsoft Entra multifactor authentication is available to customers with licenses for Microsoft Entra multifactor authentication“
When I click that last link it has a table that, amongst other things, says it’s available to “All Microsoft 365 plans“
Most of our users have Exchange Online plans, some users have Office 365 Business standard plans. Both user groups already have MFA enabled and working when for example, logging in to Outlook webmail https://outlook.office.com
Do we need extra licenses in order to install and use Azure NPS extension for Azure MFA or not?
Thanks in advance
We have interest in installing the Azure NPS extension for Azure MFA to protect our on premise remote access VPN solution. This VPN solution is a simple firewall that provides remote access (client) VPN to our users and is used in combination with our local Win2019 Network Policy Server which acts as radius to enable the users to authenticate with their AD credentials. Those AD credentials are also synced from our local AD to Azure AD Free using Azure AD connect. I’m trying to determine if I need extra licensing for the extension. The documentation says: “The NPS Extension for Microsoft Entra multifactor authentication is available to customers with licenses for Microsoft Entra multifactor authentication”When I click that last link it has a table that, amongst other things, says it’s available to “All Microsoft 365 plans”Most of our users have Exchange Online plans, some users have Office 365 Business standard plans. Both user groups already have MFA enabled and working when for example, logging in to Outlook webmail https://outlook.office.com Do we need extra licenses in order to install and use Azure NPS extension for Azure MFA or not? Thanks in advance Read More
Conditional Formatting Data/Time with XLOOKUP
Hello,
I have two columns, one of which contains a date and time in a “M/D/YY h:mm AM/PM” format, and another that contains the same, but derived via XLOOKUP. I want to enable a conditional formatting function that would look at the two columns and fill in red when the date or time do not match. For example:
1/1/23 12:00 PM1/1/23 12:00 PM1/1/23 12:00 PM2/1/23 12:00 PM1/1/23 12:00 PM1/1/23 12:30 PM1/1/23 12:00 PM1/1/23 12:00 AM
I have tried “=$A1<>$B1”, but it highlights every cell red, I suppose because the second column is derived via XLOOKUP which makes it always non-identical to the first. Is there a function that can compare the values of the cells as seen?
Hello, I have two columns, one of which contains a date and time in a “M/D/YY h:mm AM/PM” format, and another that contains the same, but derived via XLOOKUP. I want to enable a conditional formatting function that would look at the two columns and fill in red when the date or time do not match. For example: 1/1/23 12:00 PM1/1/23 12:00 PM1/1/23 12:00 PM2/1/23 12:00 PM1/1/23 12:00 PM1/1/23 12:30 PM1/1/23 12:00 PM1/1/23 12:00 AM I have tried “=$A1<>$B1”, but it highlights every cell red, I suppose because the second column is derived via XLOOKUP which makes it always non-identical to the first. Is there a function that can compare the values of the cells as seen? Read More
Viva Goals – Adding user to objective selects and adds different user
I have been trying to add a user as an owner to an OKR Objective or Key Result (same problem happening for both). However, when I try to add either of two particular users (“Data Test2” and “Data Test3”), it will instead add a user above them (“Data Test1”). If I try again, it will count up as if I’m adding more users until it hits its 10 user limit, but never adds the user I’m trying to add. If I click away and open the menu again, it will list only the 2 (the pre-existing and the erroneously added user “Data Test1”).
I’ve searched and can’t find other examples of this happening, so have no idea how to even troubleshoot this. There are no error messages; it truly just looks like a glitch. Happens for All Objectives, Key Results, and Initiatives. Only happens for two of Five users (“Data Test2” and “Data Test3”), but their settings are identical to “Data Test1”. The “Data Test1” user can be added or removed normally to any Objective, Key Result, or Initiative.
Task performed on MS Surface Laptop Studio, Windows 11, Firefox browser.
I have been trying to add a user as an owner to an OKR Objective or Key Result (same problem happening for both). However, when I try to add either of two particular users (“Data Test2” and “Data Test3”), it will instead add a user above them (“Data Test1”). If I try again, it will count up as if I’m adding more users until it hits its 10 user limit, but never adds the user I’m trying to add. If I click away and open the menu again, it will list only the 2 (the pre-existing and the erroneously added user “Data Test1”).I’ve searched and can’t find other examples of this happening, so have no idea how to even troubleshoot this. There are no error messages; it truly just looks like a glitch. Happens for All Objectives, Key Results, and Initiatives. Only happens for two of Five users (“Data Test2” and “Data Test3”), but their settings are identical to “Data Test1”. The “Data Test1” user can be added or removed normally to any Objective, Key Result, or Initiative. Task performed on MS Surface Laptop Studio, Windows 11, Firefox browser. Read More
Theme won’t stick when using multiple desktops
Is there any solution for desktop backgrounds constantly changing (by themselves) when switching between virtual desktops? This has been ongoing for a year now, and Win11 seems unable to remember and store my wallpaper preferences.
Is there any solution for desktop backgrounds constantly changing (by themselves) when switching between virtual desktops? This has been ongoing for a year now, and Win11 seems unable to remember and store my wallpaper preferences. Read More
Why am I Receiving Something is not quite right when adding a new clients?
When I actually contacted with QB online, I found out that a customer name could only contain letters and digits and could not contain a colon. That seemed to be a novel problem for me. All they say is, “Something’s not quite right. Invalid name format”. They didn’t specify what was wrong, so I was stuck on the phone for a few hours as I tried to figure it out.
When I actually contacted with QB online, I found out that a customer name could only contain letters and digits and could not contain a colon. That seemed to be a novel problem for me. All they say is, “Something’s not quite right. Invalid name format”. They didn’t specify what was wrong, so I was stuck on the phone for a few hours as I tried to figure it out. Read More
MGDC for SharePoint FAQ: How to create custom columns in Power BI
Introduction
When you use Microsoft Graph Data Connect for SharePoint, the data will commonly be visualized in Power BI.
Once you get the data in Power BI, you will find that creating additional custom or calculated columns can be very helpful. They will help you with your visualizations and enable additional ways to pivot the data.
How to Create a Custom Column
Creating a new custom or calculated column in Power BI is fairly easy. When editing a dashboard, you go to the Data column on the left and click the ellipsis (…) on the top line (name of the query) and select the option to create a new column. See below:
An edit line shows up. Just use the format: NewColumnName = Expression. Here’s an example:
You can have multiple new columns and they show up with an icon that includes the letter “fx”. You can use these columns in any of your reports or dashboards.
Data Analysis Expressions (DAX)
The expression language used by Power BI in this case in called DAX. These expressions are also used by Analysis Services and Power Pivot in Excel data models.
You can find a complete reference at https://learn.microsoft.com/en-us/dax/
As you would expect, it includes all kinds of functions, including:
date and time (date, year, month, day, hour, minute, second, weekday, dateadd, …)
financial (fv, pmt, nper, rate, sln, xnpv, yield, …)
logical (if, and, or, not, bitand, bitor, bitxor)
math (abs, roundup, power, sqrt, log, ln, rand, pi, sin, cos, tan, …)
statistical (median, stdev.s, var.s, beta.dist, schisq.dist, norm.dist, …)
text (left, right, mid, replace, trim, concatenate, upper, lower, …)
These are just a few examples. There are many other functions available.
Examples with Microsoft Graph Data Connect for SharePoint
For the SharePoint specifically, we have several datasets available via Microsoft Graph Data Connect. You can find those at https://aka.ms/SharePointDatasets. For each one, we can identify a few calculated columns that could be useful.
SharePoint Sites
Converts total bytes in total gigabytes.
TotalGB = Sites[StorageMetrics.TotalSize]/1024/1024/1024
Buckets for sites based on number of files, easy to sort.
FileBucket = IF(Sites[StorageMetrics.TotalFileCount]=0, “A:Zero”,
IF(Sites[StorageMetrics.TotalFileCount]<10, “B:1-9”,
IF(Sites[StorageMetrics.TotalFileCount]<100, “C:10-99”, “D:100+”)))
Buckets for sites based on size, easy to sort.
SizeBucket = IF(Sites[StorageMetrics. TotalSize]=0, “A:Zero”,
IF(Sites[StorageMetrics. TotalSize]<1024, “B:0-1KB”,
IF(Sites[StorageMetrics. TotalSize]<1024*1024, “C:1KB-1GB”, “D:1GB+”)))
SharePoint Groups
Types of groups commonly used for configuring permissions
PermissionType = IF(CONTAINSSTRING(Groups[DisplayName], “Visitors”), “Visitors”,
IF(CONTAINSSTRING(Groups[DisplayName], “Members”), “Members”,
IF(CONTAINSSTRING(Groups[DisplayName], “Owners”), “Owners”,
IF(CONTAINSSTRING(Groups[DisplayName], “Limited Access”), “Limited”,
IF(CONTAINSSTRING(Groups[DisplayName], “SharingLinks”), “Links”, “Other”))))
SharePoint Permissions
Role definitions by type: Full Control, Edit, View or Other
RoleType = SWITCH(Permissions[RoleDefinition],
“Full Control”, “Full Control”, “Read”, “Read”,
“Contribute”, “Edit”, “Edit”, “Edit”, “View Only”, “Read”,
“Design”, “Edit”, “Review”, “Read”, “Other”)
SharePoint Files*
Checks if a file is a Word, Excel or PowerPoint file.
IsOfficeFile = IF(
CONTAINSSTRING(“;DOC;DOCM;DOCX;DOT;DOTM;DOTX;XLS;XLSB;XLSM;XLSX;XLT;XLTM;XLTX;PPT;PPTM;PPTX;POT;POTM;POTX;”,
UPPER(“;” & Files[Extension] & “;”)), “Yes”, “No”)
Top level folder in the file hierarchy
TopDir = LEFT(Files[DirName], FIND(“/”, Files[DirName]&”/”) – 1)
OneDrive Sync Health*
Simple Yes/No column based on whether there are errors.
hasErrors = IF(SyncHealth[TotalErrorCount] > 0, “Yes”, “No”)
Converts last sync data from a timestamp to a simple date.
LastSyncDate = DATE(YEAR(SyncHealth[LastSyncedTimestampUTC]),
MONTH(SyncHealth[LastSyncedTimestampUTC]),
DAY(SyncHealth[LastSyncedTimestampUTC]))
Translates Update Ring from a number to the name,
UpdateRingName = SWITCH(SyncHealth[SyncAppUpdateRing],
4, “Insider”, 5, “Production”, 0, “Deferred”, “Other”)
Notes:
Datasets marked with * are not yet publicly available. Some of them are available as a private preview to specific customers.
Each formula should be entered as a single long line. I broke it down into several lines here for better readability.
Conclusion
As usual, these examples are shared to spark ideas and help you create your own custom columns. I hope this enables you to author better Power BI dashboards and reports.
Do you have any ideas for additional calculated columns for any of the SharePoint datasets? Share with us in the comments…
For more information about Microsoft Graph Data Connect for SharePoint, check the overview post at https://aka.ms/SharePointData.
Microsoft Tech Community – Latest Blogs –Read More
Issue with multiple windows of crashed program appearing. Any fix?
After trying to launch steam this happened. Let me know if you know any solutions for it, thank you.
After trying to launch steam this happened. Let me know if you know any solutions for it, thank you. Read More
The ‘Checked out by’ column is not available in Document library
I need to make the ‘Checked out by’ column visible in my SharePoint document library but it is not available for selection.
I tried switching to the classic experience experience the same issue.
Does anyone know how to resolve this issue?
Here is what I see.
Regards,
Jayne
I need to make the ‘Checked out by’ column visible in my SharePoint document library but it is not available for selection.I tried switching to the classic experience experience the same issue.Does anyone know how to resolve this issue? Here is what I see. Regards,Jayne Read More
Running SQLserver as a Role. Where are the tables and tmp disk stored on a bare metal server
We are currently running stand alone SQLserver as a role on a Server 2019 instance. Would like to migrate to a Hyper-V VM to make it more portable. Need to know where the tables and tmp disk are currently stored.
We are currently running stand alone SQLserver as a role on a Server 2019 instance. Would like to migrate to a Hyper-V VM to make it more portable. Need to know where the tables and tmp disk are currently stored. Read More
Can’t re-activate Windows after a BIOS update
After updating my gigabyte z790 aorus elite ax motherboard to the latest BIOS April update, I can no longer activate Windows. When I do the hardware change option under troubleshoot, I get the below message:
I purchased Windows last year. I have talked with Microsoft support, they did a number of CMD command line changes and an in-place update (reinstall of Windows) and none of these worked. They directed me here. In total, I spent 3 hours chatting with them and never got it addressed. I do not want to pay for Windows again. Thanks for the help in advance.
After updating my gigabyte z790 aorus elite ax motherboard to the latest BIOS April update, I can no longer activate Windows. When I do the hardware change option under troubleshoot, I get the below message:I purchased Windows last year. I have talked with Microsoft support, they did a number of CMD command line changes and an in-place update (reinstall of Windows) and none of these worked. They directed me here. In total, I spent 3 hours chatting with them and never got it addressed. I do not want to pay for Windows again. Thanks for the help in advance. Read More
Trying to count unique items from a data set with multiple conditions
Hi,
I just joined this community and looking for some help! I have a set of data from which I am trying to count unique items under certain categories. For example, there are multiple categories and under each of these categories, there are different items. I am trying to count how many unique items are under each category. I tried to combine COUNTIF and UNIQUE functions, but unfortunately not getting the result. What should be the best way to get a correct count of unique items under each category? Any help will be hugely appreciated!
Here is an example of the data set I have:
VendorProductDescriptionRef/serial NbrReasonRcvd DateCategoryAQF1Q44PRODUCT Q TW11831010/19/2021ACCAQF1Q44PRODUCT Q TW11841010/19/2021ACCAQF1Q22PRODUCT Q – FL11851010/19/2021ACCAQF1Q22PRODUCT Q – FL11861010/19/2021ACCAQF1Q22PRODUCT Q – FL11871010/19/2021ACCAQF1Q22PRODUCT Q – FL12621012/23/2022ACCAQF1Q23PRODUCT Q – QN12631012/23/2022BBBAQF1Q23PRODUCT Q – QN56811010/12/2022BBBAQF1Q23PRODUCT Q – QN11391303/03/2013BBBAQF1Q23PRODUCT Q – QN43441302/24/2016BBBAQF1Q23PRODUCT Q – QN43451302/24/2016BBBAQF2Q37PRODUCT Q – KG52681303/16/2023DDDAQF2Q37PRODUCT Q – KG23341306/27/2013DDDAQF2Q37PRODUCT Q – KG23381306/27/2013DDDAQF2Q37PRODUCT Q – KG23391306/27/2013DDDAQF2Q37PRODUCT Q – KG23401306/27/2013DDDAQF2Q37PRODUCT Q – KG23411306/27/2013DDDAQF1B03PRODUCT AQ – FL23432606/27/2013EEEAQF1B03PRODUCT AQ – FL23502607/02/2013EEEAQF1B03PRODUCT AQ – FL23512607/02/2013EEEAQF1B03PRODUCT AQ – FL23522607/02/2013EEEAQF1B03PRODUCT AQ – FL23532607/02/2013EEEAQF1B03PRODUCT AQ – FL23542607/02/2013EEEAQF2F04PRODUCT AQ – TW23553707/02/2013AAAAQF2F04PRODUCT AQ – TW23563707/02/2013AAAAQF2F04PRODUCT AQ – TW23573707/02/2013AAAAQF2F04PRODUCT AQ – TW23583707/02/2013AAAAQF2F04PRODUCT AQ – TW23593707/02/2013AAAAQF2F04PRODUCT AQ – TW23603707/02/2013AAAAQF2F04PRODUCT AQ – TW23613707/02/2013AAAAQF2C22PRODUCT AQ – KG23922607/11/2013BBBAQF2C22PRODUCT AQ – KG23932607/11/2013BBBAQF2C22PRODUCT AQ – KG23942607/11/2013BBBAQF2C22PRODUCT AQ – KG23992607/11/2013BBBAQF2C22PRODUCT AQ – KG24012607/11/2013BBBAQF2C22PRODUCT AQ – KG24022607/11/2013BBBABC1T22PRODUCT T – KG24035007/11/2013ACCABC1T22PRODUCT T – KG24045007/11/2013ACCABC1T22PRODUCT T – KG24055007/11/2013ACCABC1T22PRODUCT T – KG24065007/11/2013ACCABC2T32PRODUCT T – QN24095507/11/2013ACCABC2T32PRODUCT T – QN24105507/11/2013ACCABC2T32PRODUCT T – QN24115507/11/2013ACCABC2T32PRODUCT T – QN24125507/11/2013ACCDEF1A03PRODUCT A – QN918185011/27/2023DDDDEF1A03PRODUCT A – QN918195011/27/2023DDDDEF1A03PRODUCT A – QN918205011/27/2023DDDDEF1A03PRODUCT A – QN918215011/27/2023DDDDEF4A04PRODUCT A – FL918226011/27/2023EEEDEF4A04PRODUCT A – FL918236011/27/2023EEEDEF4A04PRODUCT A – FL918246011/27/2023EEEDEF4A04PRODUCT A – FL918256011/27/2023EEEDEF4A04PRODUCT A – FL918266011/27/2023EEEDEF4A04PRODUCT A – FL918276011/27/2023EEEGHI1R01PRODUCT R – TW918287711/27/2023ACCGHI1R01PRODUCT R – TW918297711/27/2023ACCGHI1R01PRODUCT R – TW918307711/27/2023ACCGHI1R01PRODUCT R – TW918317711/27/2023ACCGHI1R01PRODUCT R – TW918327711/27/2023ACCGHI3S03PRODUCT S – FL959051412/30/2023BBBGHI3S03PRODUCT S – FL959061412/30/2023BBBGHI3S03PRODUCT S – FL959071412/30/2023BBBGHI3S03PRODUCT S – FL959081412/30/2023BBBGHI3S03PRODUCT S – FL959091412/30/2023BBBGHI3S03PRODUCT S – FL959101412/30/2023BBBGHI3S03PRODUCT S – FL959111412/30/2023BBB
Hi, I just joined this community and looking for some help! I have a set of data from which I am trying to count unique items under certain categories. For example, there are multiple categories and under each of these categories, there are different items. I am trying to count how many unique items are under each category. I tried to combine COUNTIF and UNIQUE functions, but unfortunately not getting the result. What should be the best way to get a correct count of unique items under each category? Any help will be hugely appreciated! Here is an example of the data set I have: VendorProductDescriptionRef/serial NbrReasonRcvd DateCategoryAQF1Q44PRODUCT Q TW11831010/19/2021ACCAQF1Q44PRODUCT Q TW11841010/19/2021ACCAQF1Q22PRODUCT Q – FL11851010/19/2021ACCAQF1Q22PRODUCT Q – FL11861010/19/2021ACCAQF1Q22PRODUCT Q – FL11871010/19/2021ACCAQF1Q22PRODUCT Q – FL12621012/23/2022ACCAQF1Q23PRODUCT Q – QN12631012/23/2022BBBAQF1Q23PRODUCT Q – QN56811010/12/2022BBBAQF1Q23PRODUCT Q – QN11391303/03/2013BBBAQF1Q23PRODUCT Q – QN43441302/24/2016BBBAQF1Q23PRODUCT Q – QN43451302/24/2016BBBAQF2Q37PRODUCT Q – KG52681303/16/2023DDDAQF2Q37PRODUCT Q – KG23341306/27/2013DDDAQF2Q37PRODUCT Q – KG23381306/27/2013DDDAQF2Q37PRODUCT Q – KG23391306/27/2013DDDAQF2Q37PRODUCT Q – KG23401306/27/2013DDDAQF2Q37PRODUCT Q – KG23411306/27/2013DDDAQF1B03PRODUCT AQ – FL23432606/27/2013EEEAQF1B03PRODUCT AQ – FL23502607/02/2013EEEAQF1B03PRODUCT AQ – FL23512607/02/2013EEEAQF1B03PRODUCT AQ – FL23522607/02/2013EEEAQF1B03PRODUCT AQ – FL23532607/02/2013EEEAQF1B03PRODUCT AQ – FL23542607/02/2013EEEAQF2F04PRODUCT AQ – TW23553707/02/2013AAAAQF2F04PRODUCT AQ – TW23563707/02/2013AAAAQF2F04PRODUCT AQ – TW23573707/02/2013AAAAQF2F04PRODUCT AQ – TW23583707/02/2013AAAAQF2F04PRODUCT AQ – TW23593707/02/2013AAAAQF2F04PRODUCT AQ – TW23603707/02/2013AAAAQF2F04PRODUCT AQ – TW23613707/02/2013AAAAQF2C22PRODUCT AQ – KG23922607/11/2013BBBAQF2C22PRODUCT AQ – KG23932607/11/2013BBBAQF2C22PRODUCT AQ – KG23942607/11/2013BBBAQF2C22PRODUCT AQ – KG23992607/11/2013BBBAQF2C22PRODUCT AQ – KG24012607/11/2013BBBAQF2C22PRODUCT AQ – KG24022607/11/2013BBBABC1T22PRODUCT T – KG24035007/11/2013ACCABC1T22PRODUCT T – KG24045007/11/2013ACCABC1T22PRODUCT T – KG24055007/11/2013ACCABC1T22PRODUCT T – KG24065007/11/2013ACCABC2T32PRODUCT T – QN24095507/11/2013ACCABC2T32PRODUCT T – QN24105507/11/2013ACCABC2T32PRODUCT T – QN24115507/11/2013ACCABC2T32PRODUCT T – QN24125507/11/2013ACCDEF1A03PRODUCT A – QN918185011/27/2023DDDDEF1A03PRODUCT A – QN918195011/27/2023DDDDEF1A03PRODUCT A – QN918205011/27/2023DDDDEF1A03PRODUCT A – QN918215011/27/2023DDDDEF4A04PRODUCT A – FL918226011/27/2023EEEDEF4A04PRODUCT A – FL918236011/27/2023EEEDEF4A04PRODUCT A – FL918246011/27/2023EEEDEF4A04PRODUCT A – FL918256011/27/2023EEEDEF4A04PRODUCT A – FL918266011/27/2023EEEDEF4A04PRODUCT A – FL918276011/27/2023EEEGHI1R01PRODUCT R – TW918287711/27/2023ACCGHI1R01PRODUCT R – TW918297711/27/2023ACCGHI1R01PRODUCT R – TW918307711/27/2023ACCGHI1R01PRODUCT R – TW918317711/27/2023ACCGHI1R01PRODUCT R – TW918327711/27/2023ACCGHI3S03PRODUCT S – FL959051412/30/2023BBBGHI3S03PRODUCT S – FL959061412/30/2023BBBGHI3S03PRODUCT S – FL959071412/30/2023BBBGHI3S03PRODUCT S – FL959081412/30/2023BBBGHI3S03PRODUCT S – FL959091412/30/2023BBBGHI3S03PRODUCT S – FL959101412/30/2023BBBGHI3S03PRODUCT S – FL959111412/30/2023BBB Read More
Joining a Teams call from a virtual machine.
Hello,
Our users on Windows AVD cannot join a call that they answer from their mobile device.
In standard windows 10 and 11 a banner pops up when you answer a call from teams your mobile device that allows you to transfer to teams on your pc or join the pc to the call. This banner does not show up on Teams for VDI.
Thank you,
Bort
Hello, Our users on Windows AVD cannot join a call that they answer from their mobile device. In standard windows 10 and 11 a banner pops up when you answer a call from teams your mobile device that allows you to transfer to teams on your pc or join the pc to the call. This banner does not show up on Teams for VDI. Thank you,Bort Read More
Viva glint integration
Hi
Are there are any third party integration possible with Viva Glint? Can we integrate qualtrics?
Hi Are there are any third party integration possible with Viva Glint? Can we integrate qualtrics? Read More
Best way to segregate certain rows into each of their own worksheet from a primary
What would be the best way to take a single worksheet that contains multiple “record types” and copy them into their own worksheet?
The idea is to take each record type and create a copy of those in this spreadsheet into another. In this example, there would be the main sheet (shown) and 4 new sheets containing each of the rows for a record type. (Pivot table?)
What would be the best way to take a single worksheet that contains multiple “record types” and copy them into their own worksheet?The idea is to take each record type and create a copy of those in this spreadsheet into another. In this example, there would be the main sheet (shown) and 4 new sheets containing each of the rows for a record type. (Pivot table?) Read More