excel
44422 TopicsFilter Function or any Logic
Dear Experts, I have a data like below , Column "H" has rnti's , Column "F" has sfn which can range from 0~1023( and once 1023 it shall start again from 0) slots that can range from 0~9, each sfn(say 252) has slots(0~9), Column "J" is Sn( Sequence number) , In Output , I want like this, example for the rnti 384, column "B" = count of spdu-1 for the rnti=384, and so on How the spdu-1 counted? (spdu-x's are counted per rnti & per-rlcCtrlAckSn_ ,) as below for example for rnti==384, Thanks in Advance, I posted this earlier also , not sure why post got deleted somehow289Views0likes16CommentsFeature Request: Visual Studio‑Style Debugging for Arrays, LAMBDA, and No‑Code Excel Apps
Feature Request: Please enhance Excel’s formula debugging tools to support dynamic arrays and LAMBDA. Current debugging is too limited. This request focuses on desktop Excel, where debugging tools are available today. While the Mac and Web versions currently lack debugging support, these features could eventually be extended cross‑platform. Desired capabilities include cell watch, breakpoints, context debugging for array elements, and richer error tracing. Desired capabilities include: Execution Control Formula Window: trace the execution of a formula, including pausing, stepping, run-to, and start-from-here controls. Breakpoint Window: set and remove breakpoints. Data Inspection & Manipulation Data Window: collapse or inspect specific elements in an intermediate or destination array. Data Manipulation: view and alter intermediate data values, particularly LAMBDA arguments. Data Watch: monitor selected intermediate values step-by-step throughout formula execution, with the ability to break when a specific value is reached. Cell Context Cell Watch: monitor specific destination cells within an array during formula evaluation. Context Debugging: click on a cell within a dynamic array to debug that element’s evaluation path. Rules & Formatting Conditional Format: load and debug the conditional format rules for the selected cell. Data Validation: load and debug the data validation rules for the selected cell. Error Tracing & Intelligence Richer Error Context: trace where and why a formula fails, e.g., provide an execution trace log. Copilot Integration: enhance formula formatting and interpret intermediate execution steps to provide insights into issues, optimization opportunities, and potential improvements. Interface Improvements Debugger Window: resize the debugger window and display fonts; enable and resize the formula, data, and breakpoint windows. These features would make debugging modern Excel formulas more intuitive, reduce trial-and-error, help users better understand conditional formatting and data validation, empower advanced users to fully leverage dynamic arrays and LAMBDA, and realize no-code applications using Excel — with Copilot providing intelligent insights along the way.30Views0likes2CommentsExcel help
Hello Excel Community. I would appreciate some help and support if possible with Excel. I am trying to set up a racking inspection check sheet, various aisles, bays and levels. The intention is to prioritise the severity of defects for repair/replace (Red, Amber and Green) with colour co-ordinated cell fill and record one of four types of defects against the earlier colour. Examples of defects would be, Upright, Beam, Crossbar and Pins. The first 3 defects could fall into all 3 repair priorities. Any support or guidance you could offer would be greatly appreciated. Many thanks Example73Views0likes3CommentsExcel for Mac - Run-time error '1004': Method 'Name' of object 'Addin' failed
Dears, Whenever I open any Excel File (existing or blank), I get the following error message: "Visual Basic for Applications Run-time error '1004': Method 'Name' of object 'Addin' failed" Note: I don't have any VBA code in the file - again, this message also appears when opening a blank/new/empty file. I thought it could be related to one of the Add-ins that I had installed, but even after removing all of them, the message still appears. Does anybody know what it means and how to fix it? I'm running Excel for Mac Version 16.91 (24111020) from Microsoft 365 in macOS Sequoia Version 15.1.1. Thanks in advance, AndreSolved1.1KViews2likes8CommentsHow to highlight duplicated sequential rows
I have a data like below sfn can range from 0~1023, and then again start with 0, slots can range from 0~19 I want to highlight the rows like below:- so, 331.12 is repeated in ROWS(4,5) so highlighted in Yellow, 331.13 is repeated in ROWS(6,7) so highlighted in Yellow and so on. if any Conditional formatting or anyother logic, by which we can highlight these data , would be helpful. Worksheet attached. Br, AnupamSolved44Views0likes3Commentspower query/ dax measure , multiple conditions/ multiple answers
I have loaded multiple tables in power query table of revenue per category: category revenue EM01 86.000 EM02 68.000 EM03 93.000 EM04 87.000 EM05 6.000 EM06 96.000 EM07 87.000 EM08 54.000 table of share per category per accountmanager: employee accountmanager share accountmanager EM01 AM1 75% EM01 AM2 25% EM02 AM1 100% EM03 AM2 100% EM04 AM3 100% EM05 AM2 60% EM05 AM3 40% EM06 AM1 100% EM07 AM1 50% EM07 AM3 50% EM08 AM2 100% Note: in same cases (EM01, EM05, EM07) multiple accountmanagers are in charge for a category. Total of share per category is always 100%. How to organize in power query to connect both tables to get table of revenue per per category per accountmanager? Use measure? Which? Or other solution? Answer (in pivot table) should be: employee AM1 AM2 AM3 total EM01 64.500 21.500 - 86.000 EM02 68.000 - - 68.000 EM03 - 93.000 - 93.000 EM04 - - 87.000 87.000 EM05 - 3.600 2.400 6.000 EM06 96.000 - - 96.000 EM07 43.500 - 43.500 87.000 EM08 - 54.000 - 54.000112Views0likes7CommentsI broke my spreadsheet dropdowns
Somehow, the dropdowns (data validation list) stopped working within my entire workbook. It is the "Weekly Schedule Planner" template that Excel offers. I added 2 additional picks to the list. Then I updated the conditional formatting to assign them specific colors. Somewhere in this process or perhaps accessing this shared file through M365 Copilot on my phone, the dropdown arrow on the cells is gone! The options are still there when using the formula box at the top, albeit only when I backspace first. I have tried everything I can think of to get the dropdown arrow to show, and it doesn't. The first column in the To do items as well as each day is set up with the list. I used Ctrl-G to make sure there wasn't an extra cell hiding somewhere, too. We will probably start fresh with a new file in 2026, so it's not the end of the world if I have to struggle through the next six weeks, but it might be. TIA for any advice that might fix this.Solved45Views0likes2CommentsSheet View Issues with Excel Web Browser
Hi, I have created a Excel document for my department to use, I tried Excel App but due to the size of the Spreadsheet it kept freezing, as a result I switched it to use Excel through Web Browser. The sheet no longer freezes which is good. I do have another issue though.....I wanted multiple users to be able to access, edit the sheet at the same time so I did some research and Sheet View seemed to be the way forward. I created a Sheet view for each employee to use so when you go to View, Sheet View and click on the relevant person their work is updated, saved etc and this shouldn't affect others view. This is working in terms of people editing. The main issue now though is that despite following advice sometimes when someone changes a filter on their own sheet view it seems to change others view. My understanding was you can hide, filter etc within your own Sheet view but this doesn't seem to be the case.......PLEASE HELP!!!! My excel and computer Skills aren't excellent to please any simple advise would be great.25Views0likes0Comments