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 13, 2024Copper Contributor67Views0likes18Comments网上网赌客服提示维护不能提款怎么办?
网被黑平台骗客服不让你的正常下分了,我们这个时候找平台客服,只能被告知平台在维护,审核等情况,这些情况如果是多天不能到账那么就确定是你的,如果是说你违规,注单异常情况,异地登入,或者需要验证身份才能出款这些明确的要你的,只是普通找借口,被黑不给你出款联系底部!一对一解决,QQ:3854555180不成不收费。再好好的沟通。 情况1:账户被直接冻结。 方法:通过沟通了解具体情况,只要不是你对刷,你就忽悠让他们感觉你是一块肥肉,他们你的只是你的冰山一角,而且你想继续在他们那里来这里玩,让他们看看是不是误封了,赶紧帮助恢复正常。 情况2:账号可以登录,出境遇到各种渠道(平台系统、银行系统维护、订单审核、出境通道维护等)。方法:如果是综合性平台(有很多电子游戏,如MG、A7)等),可以通把分藏到那些平台下,咨询把赢的部分输回来,产生代价一定回来,不要指望全部拿回,应该有这样的心里准备,努力多拿,拿回一点是一点,即使专业人士也做不到满足你的全部要求,尽最大努力减少自己的损失。在网上被系统维护升级风控审核不给提款怎么办!就介绍到这里,本人在实体工作多年,对网的流程再明确不过,希望能挽回损失。lmg0002Nov 13, 2024Occasional Reader1View0likes0CommentsBUG: Windows Clipboard History doesn't work for search box of a filter, instead pastes into sheet
BUG REPORT: the Windows Clipboard History does not paste as expected into the search box of a column filter. Instead, the item you choose in the history end up pasting into (and potentially overwriting, causing data loss) whatever cell is currently selected. This only started with Windows 11, it worked as expected in Windows 10. Please fix this, as I very often need to use clipboard history entries to filter my tables. I have attached a screen recording showing what I am talking about. I don't know if the issue is more with Excel, or with Clipboard History. Either way, please fix this, and reach out to other teams if needed. I did also submit this report via Excel Feedback.ExcelR8Nov 13, 2024Copper Contributor219Views0likes1CommentDefault custom name of active field in Pivot Table
Hi, I found this link that shows me how to change it manually (which I already know) : https://support.microsoft.com/en-gb/office/change-the-summary-function-or-custom-calculation-for-a-field-in-a-pivottable-report-ea8945fb-9969-4bac-a16c-4f67b0f7b239 However, I'd like to set by default "Source name = Custom name". At this moment Excel always takes "Custom name = Function used + Source name" and it's inconvenient for the size of the column. It will be more efficient for me to be able to change this default setting. Thanks for your help!pnfwiNov 13, 2024Occasional Reader13Views0likes4CommentsLinking cells and sorting.
Im having an issue where i have a cell on one sheet linked to a cell on another sheet. when i sort the data on the sheet the other cell is linked to, it doesn't follow the data, it stays linked to the cell. is there a way that when i resort the source cell that the linked cell follows the data, not the cell.MattG1515Nov 13, 2024Occasional Reader8Views0likes2CommentsDate Time format not sticking
Hello, I am trying to format a column in a sheet that is frequently updated by people from all over. The Issue is with the Date column in the formula bar the date will be 30/06/2024 and in the cell it will say 30.06.2024. This really messes up when I am trying to export the data. Does anyone know why the formatting keeps breaking? TIANicolleANov 13, 2024Occasional Reader3Views0likes1CommentUnable to create dependency drop down List
Hello All, After a long search I still could not figure out how to create this dependency drop down list in excel. What should I input in Data validation:List? May I have your help on it: My target is to create drop down list in below Main column. It should be dynamic. Expected result:For apple, it should be able to select Green or Red. Orange can select Orange I will add more rows on sheet Main and sheet second if there is more combination. Seems this is simple logic but already spent hours on it :( In sheet: Main Composition column Drop down list in this column Apple Apple Orange In sheet: Second Fruit Drop down list Apple Green Apple Red Orange Orange Pineapple Yellow Thank you.SolvedCharise12Nov 13, 2024Occasional Reader29Views0likes4CommentsXLAM load error with KB 5002653
Hello, Since applied KB 5002653, My .XLAM macros are no longer loaded by Excel 2016 at startup from the Addins folder (Fine with Excel 2021). The first character of the macro files that Excel try to load is truncated (first char is missing). Everything is fine if I uninstall KB5002653. Is it a know issue with the November Update ? Thank you NicolasNicoFaNov 13, 2024Occasional Reader3Views0likes0CommentsHelp with lookup
Hello all. I can't figure this out for the life of me. I am not advanced with excel but know my way around it. I have been searching on google for a couple days and can't seem to find what I need (probably because I'm not exactly sure how to google what I need!). It is sort of an "inventory" lookup. I have a column of items with two separate check boxes showing whether or not the item is available, or if I need to order a replacement. I need anything with the "Order" box checked to auto populate in to another sheet. The closest I have came to this is "=IF" but it returns a 0 for anything not checked. SHEET WITH DATA TO LOOK UP HOW I NEED THE FORMULA TO POPULATE THE LOOKUP DATA input data from "A" column on sheet "Subway" in to sheet "Order" if "SHEET!SUBWAY A2:A11" = true for "order" column I hope I am explaining this clearly and appreciate any assistance!jwalsh21Nov 13, 2024Occasional Reader17Views0likes1CommentSearching column cells for similar text values and summarising in another column
Hi Experts I hope you can help here. To be honest without Macros not sure this is possible with formulas? I attach an example workbook with my desired results from the data. Basically we have a support ticket system for users and can export the "summary" or "titles" for each ticket. We want to have a formula to analyse the column with all the ticket titles and produce a list of common similar themed topics, and the number of deemed occurrences. Now I know this can be done either looking for an exact text word match but the difficulty comes where I am hoping excel can attempt to categorise similar patterns of words / phrases / text. Any solution via formula or am I expecting too much? Thank you for your help!Solvedmatt0020190Nov 13, 2024Brass Contributor34Views0likes3Comments
Resources
Tags
- Excel41,581 Topics
- Formulas and Functions24,069 Topics
- Macros and VBA6,253 Topics
- office 3655,798 Topics
- Excel on Mac2,569 Topics
- BI & Data Analysis2,272 Topics
- Excel for web1,836 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,578 Topics