Name Manager using for create name which is contain atleast two name.
Hello. I creating somthing in excel with tables. These tables has thier own name, and can be dynamic or not. Any way. I using list in cell to select each data from a tables column. For that I created names with the content of a column. Unfortunatly i had to make a kind of name which is contain atleast 2 columns. These can grow dynamicly. So I think a plus helper tabel is not the right sollution for that. I think about 3 kind of solution. 1. =UNIQUE( VSTACK( INDEX(Tabla1[#Data];0;MATCH("Type_name";Tabla1[#Headers];0)); INDEX(Tabla2[#Data];0;MATCH("Column_name";Tabla2[#Headers];0)) ) output #name? 2. =UNIQUE(VSTACK(Lista_A; Lista_B)) lista_A as a name output #name? 3. created a helper table with the existing names. Created another name and use the table in it. output was the elements contained by the helper tabel, and the lista_A and lista_B tables each dedicated column. So How can i create list for a cell or cells from two column which are dynamicly growing, without a user needs to touch the core modell? Best Balázs
Finding time duration between a start date & time with end date & time
Hi all! I'm looking for any formula or power query to calculate a total time duration within a day, given the start date, start time, end date, end time. Most of the dates will equal the same but there are some with the end date being the next day. I'd like to be able to exclude any overlaps as well. Currently, I have a large embedded IF formula: =IF(AND($G4=$O4,$H4<$H5,$P4>=$H5,$P4<$P5,$H4<$H3),$P4-$H4,IF(AND($G4=$O4,$G4>$G3,$H4<$H3,$P4<$P3,$H4<$P3,$P4<$P5),$P4-$H4,IF(AND($G4=$O4,$H4>$H3,$H4>=$P3,$P4>$P3),$P4-$H4,IF(AND($G4=$O4,$H4=$P4),0,IF(AND($G4=$O4,$H4<$P3,$P4<=$P3),0,IF(AND($G4<$O4,$H4<$P3,$P4>$H4),($P4+1)-$P3,IF(AND($G4=$O4,$O4<$G5,$O4<$O5,$H4<$P3,$P4>$P3),$P4-$P3,IF(AND($G4=$O4,$G4>$G3,$H4>$H3,$P4>$P3,$H4>$P3),$P4-$H4,IF(AND($G4=$O4,$G4<$O5,$P4>$P3,$P4>$H5,$H4>$H3,$H4<$H5),0,IF(AND($G4=$O4,$O4=$G5,$H4<$P3,$P4>$H5,$P4>$P3,$P4>$P5,$P2>$P3),$P4-$P2,IF(AND($G4=$O4,$H4<$P3,$P4>$P3,$P4>$P5),$P4-$P3,IF(AND($G4=$O4,$H4<$P3,$P4>$P3,$H4<$H5,$P4<$P5),$P4-$P3,IF(AND($G4=$O4,$H4<$H5,$H4<$P3,$P4>$P3,$P4>$P5),$P4-$P3,IF(AND($G4=$O4,$O4=$G5,$H4<$P3,$P4>$H5,$P4>$P3),$P4-$P2,IF(AND(ISBLANK($O4),ISBLANK($P4)),0,IF(AND($G4<$O4,$H4<$P3,$P4<$H4),($P4+1)-$P3)))))))))))))))) This seems to work for the most part but there are a few that I just can't get. I also pulled up my query and started to enter in the time durations manually and it couldnt come up with anything automatic for me. There must be an easier way for me to do this other than trying to create an IF formula for each answer that turns up incorrect. I have a screen shot below.
Microsoft 365 admin center support
I am extremely disappointed with the customer support experience associated with Microsoft 365 Business. As a business customer, I expected a reliable support system. Unfortunately, the reality has been the opposite, and I feel compelled to caution others to carefully consider their options before committing their hard-earned money to a Microsoft 365 business subscription. After purchasing Microsoft Business licenses and transitioning my services from GoDaddy to Microsoft, I lost access to my global admin credentials. This should be a straightforward issue for support to resolve, yet it has turned into a prolonged and frustrating ordeal. For the past two weeks, I have been trying to obtain assistance without success. I contacted Microsoft support over ten days ago and received a ticket, with the assurance that someone would contact me within 24 hours. No one has reached out to me—not in 24 hours, and not in the ten days since. I attempted to escalate the issue, but even then, no meaningful support was provided. This level of customer service is unacceptable for any business solution, especially one that organizations rely on for critical operations. It is unreasonable to expect customers to run their businesses effectively without access to timely and competent support. At this point, I am requesting a refund for the service that has not been delivered, and I strongly urge Microsoft to address the shortcomings in its support system. The support I received from GoDaddy in the past was significantly better. I hope no other business has to experience this level of frustration, and I sincerely urge Microsoft to acknowledge and fix these issues.How does local OneDrive determine if a local file needs to be updated?
When using multiple computers to edit a OneDrive file, a computer often fails to recognize its local copy needs to be updated, even though the file on all computers is set to "Always keep on this device." This means changes are lost with no conflict error generated. Is the OneDrive algorithm for deciding when to update a local version of a file documented anywhere? Usually when a change is made to a file, it starts uploading to the cloud within seconds. Within several seconds after the changed file is uploaded, other computers will recognize their local copy is outdated and will begin downloading the changed version. That is the expected behavior. But often, that doesn't happen. The outdated version is used to make new changes. Those new changes are uploaded successfully. No conflict warning is generated. The earlier changes are lost forever. I have not found any documentation on how local Windows OneDrive decides if its local version of a file needs to be updated. Is it looking at file size? Timestamps? If timestamps, is there a margin of time sync differences? Does the OneDrive metadata include the source device of the last upload? Not knowing any of this I cannot troubleshoot the problem much beyond establishing that the problem is not with uploading changes. OneDrive local is reliably uploading changes. MD5 hash codes in the cloud match the hash of the changed file on the source computer. I don't have time to jump through hoops with someone at frontline Microsoft support who doesn't know any more about the algorithm than I know in order to get the issue escalated to someone with the information needed to pinpoint the issuse.Sharepoint deleting data and sites
Hello, We have noticed an issue that started about a year ago in which data is being deleted in Sharepoint. When looking at this data in the Recycle bin, it will show it was modified/deleted by specific Users but these user deny ever doing such a thing. It is at the point in which we believe the Sharepoint system itself is actually deleting data possibly due to a bug. It would be odd for the employees tagged in the Modified By field to have deleted it. Our data is backed up so recovering any deleted items isn't the issue. The issue is that we are trying to get Microsoft to investigate. We have submitted tickets through the MS 365 portal but they state they only work on break/fix issues. Any recommendations? I can see searching the internet this issue has come up for many others in the past.
Best Practice guide for stretched HA farm?
Hi, Im planning a SharePoint Subscription farm over 2 data centers. Should be pretty simple. Farm will consist of: dc 1: 1 spfe, 1 spapp, 1 sql dc 2: 1 spfe, 1 spapp, 1 sql Sql servers will be AlwaysOn. Im not sure how to set up the sp servers. Is there a preferred way to set it up, with how to? Our domains have 10gb connections so should be more than sufficient for stretched and HA. Can CA site be hosted from multiple servers? How are IPs/DNS/certs handled? What else do I need to get my head around? Thanks. Swan
Unusual behaviour on my PC. Access to all Microsoft services blocked.
One Drive does not connect. Microsoft.com loads on Chrome & Firefox but the link to the Microsoft account login page is dead. Outlook.com does not load at all. Connect to VPN (same country) and access to all Microsoft services reappears. Disconnect from VPN, connect to mobile hotspot (different ISP) and problem appears again. Reinstalled windows and problem persists. Wiped HDD and installed Linux and the unusual behaviour continues on Firefox and Chromium. Weird! All other devices on broadband and mobile internet are behaving normally. Any ideas? Curse? Nation-State?Data Pulling
I'm trying to figure out the best way to pull data together from multiple tabs within an excel file. The file is made so that it can track issues within reports that are discovered. I'll try to break it down the best I can to explain what I have and what I'm trying to do. Within the file there are 5 tabs that are considered locations and they are named: LX, LV, CR, HR, FL Each tab is set up the same way with the only real important information in these columns of a table Column A - PCR Date Column C - PCR Owner Column G, I, K, M - Modification Category (1-4) these fields are actually drop down options from the Category Master List Within the file there is a 6th tab that has at able in it that is called Category Master List. Column A - Options for the dropdown in the above tab Modification Category columns Column B - Breakdown into one of three main categories (Billing, Compliance, Quality) Now this is what I'm trying to do: Fiscal Year Data (September 2025-August 2026) - I need to see how many times each of the dropdown options within the Master List show up in column G, I, K, M for each of the 5 location tabs. Monthly Data - I need to see how many times each of the dropdown options within the Master List show up in column G, I, K, M for each of the 5 location tabs along with how many times there is an entry with a date within that month. I would like to try and figure out how to put everything into one data table/chart type thing so it's easier to see and compare. Currently, everything needed is across a few different pivot tables and I would really like the data to pull itself automatically instead of me having to go in and copy all the data from one spot into another just to get the pivot results. Below is what I'm having to look at currently.
