help with formula & functions (no Macros & VBA)
Hey all, I've created a sheet that has the following columns: (A) dates, (B) names, (C) phone numbers, (D) free text & (E) Status (done or closed). The first row (frozen) contains the title of each column. I've opened another sheet (same file) and called it 'Dashboard" . I am looking to create some sort of index where I can type in (search really) for a phone number and it will return the entire rows back with all the information. Same goes to searching for a name and return the entire relevant rows (with the phone number, dates and etc). I've been trying to look for an answer online, and also tried by myself for 2 months .. and for the life of me, came back nothing but frustration. Important to mention that I can't use macros & VBA as my workplace won't allow it due to policy issues. Needless to say, the information is sensitive. Any ideas on how to do it and tackle it in the best way possible? Big thank you in advance!Excel in 2025: A Year of Culture, Craft, and Copilot
As 2025 comes to a close, one thing feels clearer than ever: Excel is no longer just something you use. It’s something you belong to. This year brought major product innovations, many powered by AI, but it also delivered something just as meaningful: cultural moments that reminded us how deeply Excel is woven into work, learning, creativity, and even competition around the world. From celebrating a milestone birthday, to watching spreadsheets light up arenas and streaming platforms, to shipping some of our most ambitious product updates yet, 2025 was a year we’re incredibly proud of. And none of it would have happened without you. Let’s take a look back. A Cultural Year for Excel Excel Turns 40! In 2025, Excel celebrated its 40th birthday—four decades of helping people think, analyze, build, and decide more effectively. What began as a simple spreadsheet application in 1985 has evolved into a foundational tool used by hundreds of millions of people across industries, roles, and continents. Over the years, Excel has adapted to new technologies, new ways of working, and entirely new audiences, without losing the core flexibility that made it so powerful in the first place. We marked this milestone by reflecting on Excel’s past and, more importantly, its future: one where data literacy, accessibility, and creativity continue to expand. 👉 Read more in Excel Turns 40: Join the Celebration! The Excel World Championship Goes Mainstream If you needed proof that spreadsheets have officially entered pop culture, look no further than the Excel World Championship (EWC). In 2025, the competition reached new heights with larger audiences, more global participation, and unprecedented attention. What began as a niche idea has grown into a true esports-style event that proves how dynamic, fast-paced and thrilling Excel can be in expert hands. Watching competitors solve complex problems live under pressure and at speed was both entertaining and inspiring. It showed that Excel mastery is a real skill built through practice, creativity and deep understanding. 👉 Read more in Congrats to the Winners of the 2025 MECC & MEWC! Spreadsheet Champions Brings Excel to the Big Screen This year also saw the release of Spreadsheet Champions, a documentary that follows six students from different countries on their unique journeys to achieve excellence in competitive Excel. More than just a story about formulas and grids, the film is about community, curiosity, and the joy of solving problems together. It captured something we see every day across forums, classrooms, livestreams, and workplaces: Excel brings people together. For many of us on the Excel team, seeing these stories told so thoughtfully was deeply moving—and a powerful reminder of who we’re building for. 👉 Read more in Celebrating the Premiere of “Spreadsheet Champions” at the Melbourne International Film Festival A Breakthrough Year for the Product While Excel’s cultural presence grew, 2025 was also one of the most ambitious product years in recent memory. Agent Mode in Excel One of the biggest shifts came with Agent Mode in Excel—a new way to approach work that moves beyond asking for help, to delegating outcomes. Instead of manually building step-by-step solutions, users can now describe goals and let Excel reason through the steps: gathering data, applying transformations, and explaining results along the way. It’s a meaningful step toward making Excel not just reactive, but proactive. Agent Mode doesn’t replace expertise; it amplifies it. 👉 Read more in Building Agent Mode in Excel The COPILOT Function Arrives In 2025, Copilot became more deeply embedded directly into the Excel grid with the introduction of the COPILOT function. For the first time, users can call Copilot like a formula, bringing AI-powered reasoning directly into cells alongside traditional Excel functions. This bridges the gap between natural language requests and structured spreadsheet logic, unlocking entirely new workflows. It’s one of the clearest examples yet of how AI and spreadsheets can work together seamlessly. 👉 Read more in Bring AI to your formulas with the COPILOT function in Excel Formula Completion Gets Smarter Excel has always been about speed and precision, and in 2025 we made writing formulas easier than ever with improved formula completion. Smarter suggestions, better context awareness, and faster recommendations mean less time remembering syntax, and more time focusing on insights. Whether you’re learning Excel or pushing it to its limits, formula completion now meets you where you are. Small improvements like this matter. They add up to a smoother, more confident experience for everyone. 👉 Read more in Introducing formula completion - A new way to write formulas in Excel using Copilot Thank You for an Incredible Year 💚 If there’s one theme that defines Excel in 2025, it’s this: progress powered by community. Every feature we shipped and every moment we celebrated was shaped by customer feedback, creator experimentation, MVP insight, and everyday use in the real world. You pushed us, inspired us, and reminded us why Excel continues to matter—40 years on. As we head into 2026, we’re excited to keep building with you. Thank you for being part of the Excel story.
too many decimals places returned with concat from field with only two decimals
Hello! I'm learning more complicated excel through here and really appreciate all of your expert help. I haven't been able to find the answer to this... I've tried fixed and trunk, and they return with errors. I"m using this: =CONCAT([@[Approx Dimentions]]&CHAR(10)&"Appox Wt (oz): ",[@[kg to oz]]&CHAR(10)&" "&CHAR(10)&[@description]&CHAR(10)&" "&CHAR(10)&[@Origin]) and it returns this (this one doesn't have an origin) Approx Dims (mm): 42 x 42 x 42 Appox Wt (oz): 3.739039972 I want the Wt to be 3.74 as it is in the "kg to oz" column that is set to number with two decimal places, and is also a result of a formula =Q6*35.273962. I have tried to change this to 35.27 and that doesn't do anything. thank you in advance for your help and understanding that I'm new
Pictures inserted in cells disappear after closing and reopening a workbook
Windows 11 Home, 23H2, 22631.4317 MS Office L T S C Professional Plus 2024, version 2408, Build 17932.20130 Example: After saving, closing and reopening workbook, this is the result: I have tried all of the generic troubleshooting, because I have seen multiple people experiencing this issue - none of them work. 1. Display options for workbook are all checked (for object, show all) 2. Pictures are embedded, not linked to locally stored files - otherwise I wouldn't be able to retain them in online platforms (e.g. opening in Excel from Android, once storing in One-drive). Even if they were linked somehow, original files were never moved. When I upload the very same workbook in One-drive and open through any online platform (via browser - Excel Online, on Android - Excel app / Office 365 app) pictures are showing as intended. Problem occurs only on desktop app. I have already tried to reinstall MS Office, clean install, all updates - problem persists. I do not want any workaround solutions like: - using VBA scripts, - or inserting pictures over cells. as this is a proper bug and shouldn't require advanced skills from casual users. Inserting pictures over cells and embedding them manually - change size to fit into cell, set Move and size with cells is just partial solution - pictures will stay after closing and reopening, but you cannot refer to them properly - e.g. I want to have a result of X LOOKUP to be a cell with Picture inserted into cell (doesn't return a picture in cell if picture is placed above cell - doesn't matter if it is set to Move and size with cells. X LOOKUP with pictures inserted in cells works perfectly until I close and reopen locally on desktop app ( #UNKNOWN! everywhere), but continues to work perfectly in before-mentioned "online" platforms - though I am a bit more advanced user and lot of stuff I do can only be done in desktop app - as soon as I want to make some more advanced actions, I need to go back to desktop and all I get is a bunch of #UNKNOWN! where Pictures inserted into cells are supposed to be. Please solve this bug - it is very frustrating - I have lost straight 12 hours of my life trying to solve it, but I am at my wit's end. Thank you very much for reply.Why can't I post my reply to this thread
Hi, Why can't I post my reply to this thread: Calculate hours using pivot table | Microsoft Community Hub I have tried several times so far to post my reply and at first moment it seems to be accepted because the page displays my replay, but after refreshing the page it "disappears", meaning it no longer exists. Anyone have any ideas? Thnx.
Chat with Copilot popup on every Excel launch
An ad for Copilot shows up every single time I open Excel. Clicking Not Now closes it, only for it to reopen again when I open Excel later. Is there any way to disable this or remember my selection each time? It is frustrating to have to deal with it all day long. I do not have a Copilot tab in File > Options. Optional connected experiences is already disabled. Microsoft® Excel® for Microsoft 365 MSO (Version 2511 Build 16.0.19426.20218) 64-bit Windows 11 Pro 25H2
Need assistance to correct a formula
I am using the following formula to calculate weekly hours. I want to change it to calculate the hours with the starting on Monday going to Sunday and display the result in column G on the Sunday. For example - calculate totals from Monday Jan 6 to Sunday Jan 12, inclusive. Thanks in advance for your help. =IF(WEEKDAY(B6)=7, IF(SUMIFS(D:D,B:B, ">="&B6-6,B:B, "<="&B6)>0, SUMIFS(D:D,B:B, ">="&B6-6,B:B, "<="&B6), ""), "") A B C D E F G 1 Date Hours Purchases Rate Daily Cost Hrs / wk 2 1-Jan Wed 5 $20.00 $100.00 3 2-Jan Thu 5 $0.00 4 3-Jan Fri $20.00 5 4-Jan Sat $20.00 10.00 6 5-Jan Sun 7 $20.00 $140.00 7 6-Jan Mon $20.00 8 7-Jan Tue $20.00 9 8-Jan Wed $20.00 10 9-Jan Thu $20.00 11 10-Jan Fri $20.00 12 11-Jan Sat $20.00 7.00 13 12-Jan Sun 3 $20.00 $60.00
Not Allowing Entries to be blank
I have a cell that is formatted for a date that will get updated by the user (F4 Below). And then column A is just copying that value all the way down. I want to prevent the information in column A from being deleted accidentally. It will likely be a hidden column, so accidentally deleting it is possible. I tried data validation and rules, and they worked in all cases except if they are deleted. How can I prevent A1 from being deleted, but still have the user be able to update the date in F4 and have A1 update.
