Pinned Posts
Forum Widgets
Latest Discussions
Multi-replace Macro
Hey all, I need some assistance creating a macro that replaces multiple phrases. Below are the phrases I have and the phrases I want them changed to without having to manually use "Find and Replace" each time. "ROr ROY" replaced with "LK Fin" "OKP and DON" replaced with "HU Dep" "Signs (Single)" replaced with "PE Dep" When I look elsewhere, I'm shown how to replace words but not phrases. Any assistance would be greatly appreciated.How to retrieve the latest unit cost
Hello, I am sharing a condensed version of a pricing file that lists from Cols A to C Item Codes and pricing by date. The goal is to retrieve the latest unit cost for a particular Item Code. Here is the link: https://docs.google.com/spreadsheets/d/1wm9Ry7PGqM0qirY6GeKu1F9ZHzR3kFrj/edit?usp=drive_link&ouid=103354753371375324640&rtpof=true&sd=true Note: the formula in Cells F5:G48 may return N/A because of the link that automatically opens up as Google Sheets. In Cells F5:G48, I have attempted to retrieve the latest Unit Cost by first bringing in Unique Item Code from the repetitive Item Code in Column B. Unfortunately, the unit cost coming in for most of the items is incorrect. For example, Item Code: ABR00054 should have a latest unit cost from 12/6/2023 of $42.98. However, the xlookup(maxifs) function that I am using is bringing in $4.53. I thought that the formula shown in Cells G5:G48 would work but something is scrambling the formula logic. Can you please point out if the formula is incompatible with the source data layout as presented in Cols A to C? Please consider highlighting another formula that will be able to provide me with the data that I am looking for. Thank you. Regards, Shams.
How to refresh excel data and remove previous data automatically
I have to update a reporting template based on an excel sheet. How could I update excel sheets automatically and remove previous data? I can upend data by using Power Query refresh. I do not want that. I want only this week's data. Last week's data should be clear.
Celebrating World Spreadsheet Day
Today we honor the humble grid that revolutionized how we work, analyze, and innovate. 🎉 Initiated by Excel expert Debra Dalgleish, this day marks the release of VisiCalc on October 17, 1979 the first spreadsheet software for personal computers. 🧠 From VisiCalc to Microsoft Excel, spreadsheets have evolved into decision-driving engines across industries. 💡 Excel isn’t just a product it’s a platform for creativity, automation, and insight. Whether you’re building dashboards, crunching numbers, or modeling space missions (yes, NASA uses Excel!), today’s the day to celebrate the magic of cells and formulas. 📊 How has Excel shaped your work or learning journey? #WorldSpreadsheetDay #Excel #Microsoft365 #DebraDalgleish #VisiCalc #SpreadsheetPower
Excel: Count cells with specific value + colour
Hi there, I would like to be able to count the number of cells that contain a specific value and are shaded a specific colour. This is for a rota spreadsheet that will be tallying the total number of shifts which have been agreed. The cells that contain "Yes" as a value from a drop down list and are shaded green, should be counted as part of the quarterly total. I'm assuming that a VBA custom function would be needed for this. I've tried a few but cannot figure out a way to get this to work with both a specific value and colour. I would be very grateful for anyone that is able crack this challenge. In the example screenshots, it is the cells shaded in green that would need to be counted and the totals appear in column GJ. Best regards, DanielExcel for Mac Character entry into cell delayed til after all return entries processed.
MBA M2 Sequoia 15.6.1 (24G90) Excel Version 16.102 This issue started after recent update. When there is a big resource demand entries into cells used to be delayed, but would run correctly when resources were available. For example: Select cell A1 Type "A" Return Type "B" Return Type "C" Return This would produce A, B, and then C in three separate cells down the column, even when resource demand was high, the entries would just be delayed but entered correctly. Now, the process when delayed by resource demand, stores all the cell entries, first runs all return commands and then puts all entries into the last cell.
