Put a specific word in a cell based on the word in another cell
Hey everyone, I need help automating the categorisation of my bank statement in excel. I do not have microsoft 365. I want excel to look for specific words from my transactions eg Woolworths or McDonalds and then based on that, put another word into the categories cell. For Woolworths I want it to populate groceries, for McDonalds I want it to populate Eating Out. Etc. I would really appreciate the help and in the most basic way possible. I only use basic formulas, so array formulas are quite foreign to me. I have tried googling and nothing seems to work quite right. Happy to move columns around, but would prefer to keep Date, Amount & Description next to each other as that is the order from my bank statement download. I also don't need the Merchant / Category section in notes, but previous attempts led me to adding them. Thanks
Hightlight date cells based on expiry
Hi, I have inherited a spreadsheet of employees who have been on various courses based on their roles, the courses either have a 12 month, 2 year or 3 year expiry date, they are ordered in their relevant columns. the dates are past dates and i need to add a formula so i can see when each person is 60 days out from needing to renew their course (amber) is over the due date (red) and the rest can be green, this gives me enough time to book the ambers in with pleny of notice and shows the current expired courses to prioritise. i think i can use the TODAY() formula but as each date field is a historic date i need to work off each individual field to give that persons due dates as they have gone on courses at different dates from each other. currently it is a nightmare tyring to keep track and i need a simpler visual que. any help would be great. thank you.
How can I find merged cells in a large spreadsheet?
The file has around 80,000 cells. When I tried a new sort, it said "To do this, all the merged cells need to be the same size". I use merged cells fairly often, but I can't remember where I did that in this file (it's even possible there are none). So I followed the Help instructions for 'Find merged cells' but at the final 'Find All' step, I got "We can't find what you were looking for. Click Options for more ways to search." Any suggestions/solutions?
Allow removal of "Copilot Suggestions" from right-click menu
I have been using Excel for decades and CONSTANTLY use the right-click menu for quick access to basic functions (e.g., "Insert"). Ever since "Copilot Suggestions" was added to the drop-down list, it always throws me off due to its placement. I have Microsoft 365 on Windows 11 Pro. I have searched for ways to remove this from appearing there and the result said "go to File > Options > Copilot and uncheck the 'Enable Copilot' box". However, when I attempt to do that, there is NO "Copilot" option available! PLEASE allow removal of "Copilot Suggestions" from the right-click menu OR at least the option to move it to the bottom (so it isn't in the way of things used ALL the time). I realize that Copilot is a great resource for many users, but I am confident in my Excel skills and in my ability to research/learn new skills the "old school" way, so I have little use for this feature now and would prefer to hide it.Welcome to the Excel Community
The Excel Community is a place we've built for all of you. You can learn more about how to do something with Excel, discuss your work, and connect with experts that build and use the product. With over half a billion Excel customers, we want to engage with you in fundamentally different ways and the community is a starting point for that. Our community helps answer your product questions with responses from other knowledgeable community members. We love hearing feedback and feature requests from you which helps us build the best version of Excel ever. If you have found an outage or a bug please post at our Answers forum. We look forward to getting to know you! Sangeeta Mudnal & Olaf Hubel on behalf of the Excel TeamExtract Functions from a Formula
Hello, I often go to the Excel BI Challenges on linked in. I have started my own spreadsheet that I use as a reference. Anyway, what I do is take one of the formulas that has been given in the comments of the challenge and then try to break it down and learn from it. I think the best way would be to give an example. In challenge number 379, my contents page looks like this for this challenge: The formula I used is given by Bo Rydobon who often gives great formulas as well as a host of others. Underneath the formula, you can see that I manually type in all of the functions used in the formula and then I have a LAMBDA formula that takes that list and sorts it ( =LAMBDA(A,UPPER(TEXTJOIN(", ",,SORT(TEXTSPLIT(A,,", "))))) ) Your mission, if you choose to accept it is to figure out a formula that will extract all the functions from the formula ideally sorting them with the assumption that all variables are lower case and only the fucntion names are in upper case. Here is the formula again that is not a picture: =MAP(A6:A14,LAMBDA(a,LET(n,--TEXTSPLIT(a,,","),TEXTJOIN(", ",,MAP(DROP(n,-1),SEQUENCE(ROWS(n)-1),LAMBDA(m,i,REPT(m,AND(m<DROP(n,i))))))))) Thanks in advance. PS Bonus Question. This formula uses an AND function; but only gives one argument. Is this because the array contains more than one value? What reasons would use the AND or OR and only use one argurment. Thanks again.
