Forum Widgets
Latest 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.xlsxJumbergNov 06, 2024Occasional Reader24Views0likes7CommentsHow 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?nq003524Nov 06, 2024Copper Contributor122Views0likes4CommentsSearch 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 FoundRodney2485Nov 06, 2024Copper Contributor4Views0likes1CommentEmployee Attendance Tracker
Is there a video on creating this type of template? If not can I add to the types of leave?SolvedAcesKHNov 06, 2024Copper Contributor44KViews0likes14Commentsexcel
the experience of excel sheet in my laptop is very bad experience i thought that for my laptop manufacturer was differently manufactured. its totally different then others even not working properly buttons also many more problems are i faceing so pls manufacture make it solve my problem.rahulpatil4Nov 06, 2024Copper Contributor7.5KViews0likes2CommentsText 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?Marco_CVNov 06, 2024Occasional Reader45Views0likes7CommentsPower 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🙂🤗Insert_KeyNov 06, 2024Brass Contributor344Views0likes17CommentsLoan 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 AdvanceCORY WESTNov 06, 2024Copper Contributor3Views0likes0CommentsMaking Money from Excel
Hi Experts, Do you have any ideas or tips on how to monetize 💲 our Excel skills? How to make MONEY 💰 from Excel?Haytham AmairahNov 06, 2024Silver Contributor85KViews0likes14CommentsExcel 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 KumarvipinpanwarNov 06, 2024Occasional Reader5Views0likes1Comment
Resources
Tags
- Excel41,511 Topics
- Formulas and Functions24,026 Topics
- Macros and VBA6,237 Topics
- Office 3655,786 Topics
- Excel on Mac2,568 Topics
- BI & Data Analysis2,267 Topics
- Excel for web1,831 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,574 Topics