training
1027 TopicsConditional formatting
I'm making a rule to Highlight cells in Column AZ when the value is lower than Adjacent cells in Column P. For the most part it works except for two cells in AZ (1 shown as an example) that are higher than P but are being picked up by the conditional formatting. The two cells I'm focusing on here are P14 (£0.27) and AZ14 (£0.43). £0.43 should not be being highlighted pink as it isn't lower than £0.27. This has to be something obvious but I have looked at it too long. Please help if you can :)Solved315Views0likes3CommentsLooking for advice on leveraging AI for Excel in a price-sensitive, third-world country
I work for a training company in a price-sensitive, third-world country and have been conducting training in MS Excel for close to 2 decades. My company has asked me to design Excel training that teaches how to use AI to improve productivity. Ethical considerations aside, it’s something I have been thinking about for a while. The main roadblock I see is the average purchasing power of participants in our market. Right now the cheapest Copilot plan is USD 99.99/yr for MS 365 Personal. The cheapest plan for Business or Enterprise is USD 18/user/month for MS 365 Copilot business (billed at USD 216/user/year). I’ve been casually speaking with the participants in training sessions and most are happy with the free chatbot versions of Copilot/ChatGPT/Gemini that almost no one would upgrade to a paid subscription to integrate AI with Excel - they describe their problem to the AI, send screenshots or upload files and then try and implement the solution that’s returned. It’s similar in the business/enterprise context. Larger organisations may have paid for AI subscriptions for their employees but those are few in number. Most businesses in this market are classified as Small-Medium-Enterprises (SMEs) and feedback from participants is that their management would not likely approve of the cost. It’s worth mentioning that my training company does not provide computers instead requiring participants to bring their own laptops with valid Excel licences though we standardize things as much as possible e.g. Windows only, no tablets etc… This means if we design a training that requires a paid Copilot subscription, then it is up to the participants to buy it for themselves which I don’t think many of them will. After speaking with management, they are open to designing a training that uses the free AI chatbots. I’m fine with that but don’t know how much value that would add to what people are already doing. I’m quite sure this strategy is management trying to revive Excel training which used to be top-sellers (demand fell off ever since COVID) and they see other Excel training incorporating AI so want to follow suit. So right now the most viable option is to create training that teaching using free AI chatbots. But I’d like to hear the opinions of others - what other options do you see for a price-sensitive, third-world market? And yes, I did ask AI how Excel users can leverage AI without paying for expensive subscriptions and it basically said “use the free chatbots”.236Views0likes1CommentRemove a comma from a number treated as text
Greetings! I'm new to this forum, and I don't know if this is the right place to ask. But, here it goes: I have a column of currency values which is a mess. I managed to clean it as much as possible using the functions SUBSTITUTE and TRIM. These functions transformed the unformated numbers into text, and now it looks something like this: 6,764,68 1,319 1,948 301,40 2848,08 The former is a sample from 165 entries. Is it possible to remove the first comma of the string, so the values look like this instead? 6764,68 1319,00 1948,00 301,40 2848,08 What I would like to do is to remove the second comma from right to left in each value, while keeping the first which marks the cents of the transaction. Can this be done? Thanks all in advance :D507Views0likes3CommentsGLSU Excel add-in fails to load after Office update from Version 2607 to 2608
Our Excel add-in, Process Runner GLSU , fails to load after Microsoft Office updates from Version 2607 to Version 2608. This started August 17, 2026 and is actively growing in scope. Error messages: Excel: Cannot run the macro 'onLoad' VBA: System Error &H80004005 (-2147467259). Unspecified error VBA: Compile error in hidden module: ThisWorkbook Has anyone encountered similar issue with their own custom add-on. If yes, any pointers to fix it. We are seeking help on priority. Thanks, Vrushali Pawale, Sr. Manager, Insightsoftware.1.2KViews0likes1CommentScenario basic help please
Hi. I have a spreadsheet which calculates electricity usage and solar input etc. As the price keeps changing I am putting the new prices into the spreadsheet. I was thinking that I could use Scenarios or similar to be able to see what the bill would have been previously. I have looked at the Scenario instructions but I'm not quite sure how to use it (bit rusty in Excel recently). Is there a training video or similar I could watch. Any help gratefully received. Regards Bluey355Views0likes2Commentscombine multiple text into single line of text
Hi is there a way to combine all the cells into a single cell (of text) ignoring the duplicates/repeat values. i know concatenate but that function becomes very lengthy as ill have to define every cell into the function individually. is there any other function where i simply select the entire data (like an array) and it can do the required.Solved347Views0likes3CommentsGetting started in Excel Labs Custom Modules (missing "publish" step)
First-time poster — please be gentle! Context Excel for Mac I have a large library of LAMBDA formulas and wanted to manage them using Excel Labs In particular, I wanted to organise formulas into custom Modules Issue How to actually activate functions defined in custom Modules in Excel Labs I recently discovered Excel Labs and was very excited to use it to manage and structure a large library of LAMBDA formulas. My goal was straightforward: create custom Modules to organise formulas by purpose, and then use those formulas in the workbook. However, it took several hours of experimentation and debugging — even to get a trivial example like: ABC() = 12 to work when defined in a custom Module. The missing piece (which Copilot, Google searches, and the README all missed) is this: Functions defined in custom Excel Labs Modules are inert until the module is imported into the special Workbook module. Until that import step occurs, functions in custom Modules: do not appear in Excel Labs → Names do not appear in Formulas → Name Manager are not callable from the grid According to Copilot this behaviour is not currently documented, and the UI strongly suggests that custom Modules are “active” by default — which they are not. Working workflow (for others who hit the same issue) This is the workflow that finally made things work for me (possibly sub‑optimal, but reliable): Create and maintain functions in custom modules (e.g. Transformations) Explicitly import the required functions into the Workbook module, e.g.: TransformAtoB = Transformations.TransformAtoB Workbook module now publishes to: Excel Labs → Names Formulas → Name Manager This makes conceptual sense — maintain a large structured library of formulas (or import libraries from GitHub), only activate the formulas required by a particular workbook. But without documentation, it’s very easy to assume custom Modules are active by default. Why I’m posting this When I finally asked Copilot “Why didn’t you say this up front?”, the answer was essentially: This publish step is not documented in the README or the UI, and users are easily led to assume Modules are active by default. So I’m posting here to save others from repeating the same debugging journey. Documentation request It would help enormously if the documentation (README / FAQ) stated explicitly that: Custom Modules are source-only Importing into the Workbook module is the publish step Only the Workbook module is wired to Name Manager and the Excel grid Even a short note would remove a major stumbling block for new users. I’m not a GitHub user, otherwise I would also raise this there — if someone from the community is able to mirror this feedback on GitHub, that would be much appreciated.167Views0likes0Comments