Recent Discussions
Text to numerical value
Hello all, I need to start by saying I am an absolute dinosaur, so don't really understand the coding language used, which I think is where I am going wrong as I don't understand it! I have created a timetable sheet. I have 4 teams and 5 possible shifts to select. The table auto calculates from the master box at the top and adjusts all the related shifts for all the teams. It colour codes and calculates the pattern and hours fine, but would love it if from the drop down list on the cells, if it showed in the LIST, the names of the shifts, Earlies, Lates, etc, but appeared in the cells as the shift times (showed numerical value 0700-1600) and I am being bamboozled by the terminology. Can anyone help please?Blog about Troubleshooting Steps for SharePoint Online
SharePoint Online, part of Microsoft 365, is a powerful collaboration tool that helps organizations manage documents, workflows, and content across teams. However, like any platform, SharePoint Online can occasionally run into problems. Below are some common issues users face and troubleshooting tips to resolve them quickly. Full blog: https://dellenny.com/troubleshooting-common-issues-in-sharepoint-online/
School Master Calendar
Hello I am in charge of putting together a master calendar for our school community. This would be a behind-the-scenes calendar utilized for planning events and spaces within the school. I started out by using a calendar template in Excel called "Family Event Calendar." At first I thought this was going to do EXACTLY what I needed it to do---take a master list of events and apply them to a monthly calendar format in the workbook. Unfortunately, I ran into a problem where only one item will be listed for each day of on the calendar--as we are a school, there are usually a good handful of things on each date. With that, I started working on my own. I have successfully set up a workbook that has a master sheet that lists date, event, start time, end time, location, department, and category of the event. I have set up formatting rules to color code by the category column. I have figured out how to distribute from the master sheet to a separate sheet for each month. This alone will certainly be helpful for us in our planning. However, putting the items into format of a typical month calendar is desired. Here is a viewable link to the document I have put together thus far New Master Calendar Attempt 11 4 2024.xlsx
How to make your formula jump rows
I'm the percentile function to calculate 20 and 80 percentiles from a list of data registered to a date. I need to work it out month by month. However when I drag my formula down it only goes down one row where I need it to go down to the next month. Is it possible to jump down 30 or so rows or is there another way of doing it?
Search product, return Found, Not found or leave blank if no data entered.
I have a file with different product numbers and i'm trying to create a search function that returns a Found, Not Found or Leaves cell blank if no data is entered into the search. Using IF(Vlookup I can get the product to return in the result box, but I want it to say Found or Not Found Using a different Iferror(If(Vlookup I can get a non-found result to return correctly, but it doesn't show blank when nothing is entered in the search box. It'll also return false if Product is found, so I know i'm doing something wrong with that formula. Top box is what I currently have, bottom box is how I want it to be. Enter Product Number Result WA10649 WA10649 WA111577 Not Found Not Found Enter Product Number Result WA10649 Found WA111577 Not Found
"New Outlook" Inbox not updating
In the "New Outlook" (which appears identical to the current web version of outlook): whenever I get a new email, I will get a notification and the unread counter next to my inbox tab will increase by one... but the email itself will not appear in the inbox UNTIL I click out of the inbox and back into it! It doesn't appear that the inbox can refresh itself "on-the-fly" as new emails come in, it only refreshes itself when it is loaded up! Are others experiencing this issue? I seesvheldenposted about it a year ago but they said a software update fixed it... to me it seems to still be occurring with both the desktop and web app.
Text wrapping in a cel with formula
Hello, I'm new on this community so please don't offend if I approach my problem in an incorrect way. I've been looking in previous threads to find an answer, but can't seem to find it. I have an Office365 Excel sheet with separated collums like Company, Contactperson, Address, City and Country. I want to combine data from the different collums in 1 cell, for instance with the following formula: ="Company: " &A1 &", Contact: " &B1 &", Address: " &C1 &", City: "&D1 &", Country: " &E1 This results in the following information: Company: CompanyName Ltd., Contact mr. John Smith, 32 Church Lane, Amsterdam, THE NETHERLANDS So far so good, but I want the result lines in the cell to be wrapped so every line is underneath eachother, like this: Company: CompanyName Ltd. Contact: mr. John Smith Address: 32 Church Lane City: Amsterdam Country: NETHERLANDS As far as I have seen, a break line in an Excelcell can be done by using CHAR(10) So, I thought to set the cell on "Wrap text" and use the following formula: ="Company: " &A1 &CHAR(10) &"Contact: " &B1 &CHAR(10) &"Address: " &C1 &CHAR(10) &"City: " &D1 &CHAR(10) &"Country: " &E1 However, this formula is not accepted and results in#NAME? Does anyone have an idea what I'm doing wrong and how to get the result I'm looking for?Power Query - removing identical generic text from the start and end of multiple columns
Hi all. I am after a hand in removing some default system values from a Jira export that I am using to build a report around. When multiple values are recorded in the system, a new column is created in the export and number is appended to any duplicate columns example"Label" and "Label2". I previously received assistance in understanding the code to merge the values in these columns and rename them, thank youLorenzo.For any columns that have required merging, I have been able to address their naming as part of the process, but I have multiple columns whose headers still require attention and can be handled as part of a grouped transformation process due to each containing identical redundant values. When a custom field is created, Jira wraps the value with "Custom field (" and ")", for example "Custom field (Country of Origin)". Some of the headers have valid values contained within brackets, so I can't simply replace all brackets - I have tried using the"Custom field (" as a string to identify relevant headers to useText.Start(_,Text.Length(_)-1) to get rid of the trailing bracket andthen Text.End(_,Text.Length(_)-14) to remove the leading text... but ended up with a list of correct headers but no data. Clearly out of my depth but felt frustratingly close. I also attempted to useList.Transform(Table.ColumnNames( )and removed the leading text and bracket... but then couldn't get rid of the trailing bracket. I had a fair crack at it today but haven't managed to get it to do what want and now my brain hurts, so have created a very simplified version of what I am trying to do and am seeking your help. In the Output tab of the sample file, merging of columns has been completed and I would like the columns Custom field (Weight), Custom field (Organic (Y/N)), and Custom field (Multipack (Y/N)) transformed into Weight, Organic (Y/N), and Multipack (Y/N). I am after a solution that searches for and replaces text in the headers rather than explicitly referencing column names as the export's contents are variable and dynamic in nature, and there are far more of them. Thanks in advance🙂🤗Loan Amortization Schedule
Looking for a Loan Amortization Schedule that will allow me to input random principle payments throughout the entire. Example: If I have an extra $1000 to put towards the principle in August I can put that in and not have it become a set payment every month. Right now everything I find only allows me to setup a standard every month extra payment. Any links to something like that or help with it would be greatly appreciated. Thank You In Advance
Generated TOC, when using RD field code, yields every page as page 1
I have 37 separate Word documents. Word version isMicrosoft Word for Microsoft 365 MSO (Version 2405 Build 16.0.17628.20006) 64-bit. I have a separate document to generate a table of contents (TOC) using the Reference Document (RD) field code to reference my 37 other documents. This worked great until recently when I generate the TOC, all headings came in correctly and every one of them showed page 1 in the TOC. I can create a single document with all my files and generate the TOC with correct page numbers with no issue. It is using the RD to create a separate TOC file where the page numbering bug rears its ugly head. Any help is greatly appreciated.Excel Performance Issue with Linked Workbooks - Data Update Delay
Hi Microsoft Community, We are experiencing a performance issue with linked workbooks in MS Excel. Here’s our problem statement: We have two workbooks (Workbook1 and Workbook2) that contain one or more worksheets. Workbook1 (Sheet-1) is linked to Workbook2 (Sheet-1) using standard Excel formulas to connect specific cell data. However, when we update cell data in Workbook1 (Sheet-1), which is linked to Workbook2 (Sheet-1), it takes approximately 10 minutes for the data to reflect in Workbook2. The records we are working with are in the thousands, which may contribute to the delay. We are looking for any possible optimizations or solutions to reduce the time it takes for the data to update. Any guidance or suggestions on how to improve this performance issue would be greatly appreciated. Thank you in advance for your help! Best Regards, Vipin KumarHow get Refinitiv/Microsoft to refresh/update stock list ?
Hello, I have shares of 2 companies, which are not found in the Stock Data types. These are fairly new shares, which listed about 2-3 weeks ago. How do I get about requesting Microsoft to update/refresh the list of shares ? The data comes from Refinitiv. So looks like an issue at their end. I have given feedback from excel to MS multiple times, but nothing has happened. This had happened once last year as well. However after a few days that share got added. Thanks.2 Stocks missing from Stocks Data type in excel
Two stock are missing from the Stocks data type. 1. Premier Energies Ltd listed on the National Stock Exchange (NSE) of India & Bombay Stock Exchange (BSE). XNSE:PREMIERENE. 2. Bajaj Housing Finance Ltd. listed on the same exchanges as above. Both are newly listed stocks. First one listed on 3rd September 2024. Second listed today i.e. 16th Spetember 2024. How to get these added ? I have given feedback on the 1st one multiple times. Where to log a request ? Thanks.Converting excel data into a printable calendar template
My work runs about 200 events per year. These are listed in an excel spreadsheet. However they also have a word template which has the layout of an annual calendar. This means there are months across the top, and dates down the left hand side (like those big annual calendars you see on a noticeboard). Everytime they add an event or edit an event, it has to be done in the excel spreadsheet manually, and then go into the word spreadsheet manually. I am wondering if there is a way to update it in excel and it magically links to a template (or app) that has the look of a wall calendar. It seems there is a lot double handling and opportunity to make mistakes. Thanks TammyMS Word Mac lagging/freezing
In the last few days (November 2024) my MS Word for Mac has been either freezing, or running very slow. I type letters and they take over 30 seconds to appear. Other times, the program just freezes altogether (though it does not appear as frozen in the "force quit". I have tried rebooting several times, closing other programs, etc. but no luck.
Events
Learn, Connect, and Be Inspired at ESPC24
The countdown to ESPC24 is officially on! One of Europe’s largest community conferences, ESPC24 is your opportunity to expand your Microsoft 365 and A...
In-Person
Recent Blogs
- Learn more about changes to contacts we're bringing to Outlook Web App (OWA)!Nov 06, 2024
- We are excited to announce a new function, TRIMRANGE, and a set of new reference operators.Nov 06, 2024
