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 #SpreadsheetPowerExcel: 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.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 TeamSpreadsheet Day - Celebrate the grid that changed everything
October 17 marks a quiet revolution. On this day in 1979, VisiCalc shipped—the first electronic spreadsheet—and suddenly, anyone with a computer could model ideas, track budgets, and make decisions faster than ever before. That simple grid of rows and columns became the backbone of modern business, education, and creativity. How Did Spreadsheet Day Begin? Spreadsheet Day was created in 2010 by Excel MVP Debra Dalgleish, known worldwide for her work at Contextures. Her goal was simple: celebrate the spreadsheet’s impact and the vibrant community around it. She chose October 17 to honor VisiCalc’s release—the moment spreadsheets went digital and changed everything. A Quick Look Back Before spreadsheets, recalculating a budget meant erasing and rewriting by hand. VisiCalc changed that overnight, and Excel carried the torch—bringing charts, formulas, and collaboration to millions. Over four decades, spreadsheets have evolved from static tables to dynamic engines for analysis and storytelling. They’ve powered breakthroughs in science, finance, and even art. Beyond the features, spreadsheets represent something bigger: empowerment. They give anyone the ability to turn raw data into insight. That’s why Spreadsheet Day isn’t just about software—it’s about the people who use it to solve problems every day. Debra’s vision sparked a tradition that now spans the globe. Educators, analysts, and enthusiasts join in each year to share tips, stories, and appreciation for a tool that empowers millions—a reminder that community matters as much as technology. Meet the Spreadsheet Champions Celebrate Spreadsheet Day with a sneak peek at Spreadsheet Champions, a documentary that goes beyond formulas to tell a human story. This film follows six students from around the world as they compete in Microsoft’s Excel challenge. Each brings unique hopes and struggles—whether it’s De La Paix in Cameroon aiming to make his family proud, Carmina in Guatemala finding refuge in math, or Mason in the U.S. balancing his love for spreadsheets with quirky hobbies. Alongside Alkmini from Greece, Nam from Vietnam, and Braydon from Australia, these young competitors reveal how mastering a spreadsheet can unlock confidence, opportunity, and even friendship. It’s a celebration of resilience, creativity, and the influence of spreadsheets in shaping lives today. Watch the trailer below: Why We Celebrate Spreadsheet Day isn’t about nostalgia—it’s about recognizing the creativity and problem‑solving that spreadsheets unlock. Every chart that clarifies a decision, every formula that saves a late night, every model that helps a team plan better—that’s the legacy we’re celebrating. Today, spreadsheets are everywhere: in classrooms, boardrooms, and even living rooms. They’ve helped launch companies, plan weddings, analyze sports stats, and map out personal goals. Spreadsheet Day is our chance to pause and appreciate the tool that makes all of that possible. Share Your Story We want to hear from you! What’s your favorite spreadsheet memory? What tip or trick changed the game for you? Post your story on social with #SpreadsheetDay, or drop it in the comments below. We’ll be reading and sharing some of our favorites. Your experience might inspire someone else to try something new. Happy Spreadsheet Day! Join the conversation with #SpreadsheetDay, and let’s keep building the future—one cell at a time.