Recent Discussions
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.xlsx8Views0likes2CommentsHow 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.266Views0likes3Comments2 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.259Views0likes1CommentConverting 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 Tammy189KViews0likes75CommentsMS 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.2Views0likes0CommentsNeed help with holiday scheduler
Hi everyone, i'm currently working on adjusting below screenshoted table in which i have dropdown for every single day and name from which i can select reason for absence. One of the reason is HomeOffice attendance. This sheet is protected so people cant just assign holiday to themselves. I would like to have permission in this sheet for specific person to assign only specific reason. Lets say, Name1 can assign only HO from dropdown to him/herself and nothing else from dropdown. Does anybody have any idea how to do this? Is it even possible? Thank you in advance for all your ideas.25Views0likes2CommentsGenerated 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.1.6KViews0likes9CommentsCells font color based on input formula in Excel
Hi! I would like to change the font color of the cells of row "K" based on the input formula. For example if the formula is=$C$2*J9 then the font color of cell "K9" should be blue, if the formula is =$E$2*J9 then should be red. So if the formula contains $C$2 then blue, if it contains $E$2 then red. Its a big table with many rows and columns and it's a bit slow to color the cells by hand. The conditional formatting is not working in this case so is there any other idea for this? Is it possible to do it without macros? It's (hopefully) only one project, so some "simple" solution would be great (if it exist). If only macro works then let be macro. Thank you!Solved29Views0likes5CommentsError [Cloud Scripting]: Cloud scripting upload failed
I Team, I have this error during the deploy from unity, below the error in detail: Error [Cloud Scripting]: Cloud scripting upload failed Exception: Running process exited with error code : 1 ErrorMessage : here another screen of the error from the mesh publish dialog2Views0likes0CommentsText 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?24Views0likes3CommentsI need a function to return last date of update
Hi I need a function to do this case: in the attached file, based on the values of cells range A3:L19 and the values of cells range A1:L1; if there is data (P OR Number value from (1 to 5)) in the range (A3:L18) or the values of range A1:A18 are equal to (True), I need a function to return the last date of update which is a value from the range (B2:B18) in this case; it should be the last date of update 16/10/2024 Thanks.493Views0likes22CommentsExchange Online Adds Delicensing Resiliency
Microsoft announced Delicensing Resiliency, a new feature for tenants with over 10,000 paid seats, to avoid inadvertent data loss due to licensing errors. Essentially, the feature adds an extra 30-day grace period post license removal during which mailboxes work as normal. The idea is that administrators will have extra time to detect and fix licensing errors that lead to mailbox removal. Overall, the new feature seems like a great idea (for large tenants). https://office365itpros.com/2024/11/06/delicensing-resiliency-exo/2Views0likes0CommentsMS Forms is failing to save changes and new form information
Across our organization we are experiencing an issue where MS Forms is not saving any changes or maybe a handful out of many to a forms and not saving new forms (saves as untitled with no content). Is anyone else experiencing this issue? We rely heavily on forms and may need to find another platform if not resolved soon!27KViews3likes15CommentsTrying to use a spill range as a reference for FILTER that uses INDEX
Hi all!👋😊 I am trying to find a solution that will let me use the values in a spill range to query a table and return related values from another column. I attempted to do this using this formula:FILTER(INDEX(Table1,,7),INDEX(Table1,,9)=$F3#,"") - where $F3# is the spill range, its values are in column 9 of Table1 and the required value is in column 7 of the same table. The formula results in an error and I was unable to resolve it to a working state. Instead, I went for a clunky but simple query that references a bunch of rows where the spill will occur. It fetches the values that I need but is not dynamic... ideally the solution would expand and contract with the spill range. I'm sure it's possible, but just beyond the reach of my current skill set or knowledge so created a sample workbook with dummy data, hoping it might help someone suggest a more elegant solution🤞 Thanks in advance, Andy!Solved788Views1like7CommentsSorting a table with groups of people (no VBA)
Hi, I have a table with groups of people in a team.The individual team can vary from 3 to 4 persons. The table list the group and their group score/result (se attached image). How can I sort the table so that the team with the highest score/result is listed in ascending order and keep the team members together? Any help or hint is very much appreciated.Solved474Views1like9CommentsHide data records collected via Microsoft forms based on user account or group membership?
We have a Microsoft form where people from different departments need to log things. But for privacy reasons, it should not be possible for person A using the form for logging things for department A to read the items logged by person B working for departement B. Person A and person B need the same view when filling out the form (they need to see the samen fields, among them the field "department"). But when the form is filled out and submitted, when looking at the data collected by the form, person A should only see the data records where department = department A en person B should only see the data records where department = department B. How can this be achieved in Microsoft Forms?53Views0likes3CommentsPower 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🙂🤗340Views0likes15CommentsHow to Compare Multiple Scenarios Dynamically in Excel Without Displaying All Scenarios in One Table
Hello everyone, I’ve created a dynamic cash flow model in Excel that is based on four different scenarios. Each scenario is selected using a formula (CHOOSE) that pulls the scenario from a specific cell, so only one scenario is displayed at a time. However, I want to create a dynamic comparison table that can show key parameters (such as revenues, expenses, etc.) for all four scenarios at once. The challenge is that my model currently only displays one scenario at a time, and I don't want to manually input all the data for each scenario into separate tables. Is there a way to set up a dynamic table or solution in Excel where: I can compare all four scenarios simultaneously in one table? The data should update dynamically if the parameters change. I do not want to manually insert all the data for each scenario as constants. Any suggestions on how to achieve this dynamically in Excel?16Views0likes1CommentForms improvements
There are a set of features I would like to see implemented: 1 - Possibility of classifying the choice possibilities in multiple choice questions. Example: 2 - Possibility of making the total available per section after submitting the questionnaire; 3 - Drag-and-drop questions; 4 - Possibility of classifying the options in "linkert" type questions and obtaining the result of the question, which may be the sum or the average. 5 - Education Teams the possibility of creating a question bank to create random questionnaires.27Views0likes1Comment
Events
Recent Blogs
- We are excited to announce a new function, TRIMRANGE, and a set of new reference operators.Nov 06, 202417KViews4likes31Comments
- Learn more about changes to contacts we're bringing to Outlook Web App (OWA)!Nov 06, 2024678KViews7likes110Comments