Filter 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 somehow
Excel 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 ExampleHow 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, Anupam
power 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.000
Creating Formulas but not responding as expected.. Due to format of cell?
I have a large moderately complex workbook for forecasting / projecting a financial situation for next 30 years. It references data on multiple sheets. I'm using Accounting format, but I have removed / shifted the decimal places so it shows Custom for the format. It has been working fine, but yesterday when I attempted some changes, all of a sudden when I create a formula, even something as simple as =H36 or as simple IF statement, the cell remains empty or shows 0! I just tried something in some unused cells, where I did a simple =E31, which contains the value 12%. Three of the four cells show 12% the other $ 0. The three that show 12% were probably General to start, but now show percentage. The one that didn't show 12%, was Custom, from me using it previously to test thigs. I then formatted a blank cell Accounting and shifted decimals (sand it reacts the same way, and show $ 0, not 12%. What is going on? LOL E31 is manually entered 12% I entered =E31 in each of these cells below. (It won't let me use a table here...) They started as General. The one that doesn't show 12% was preformatted Accounting but with decimals shifted, so it shows Custom. The last one I formatted as Accounting without removing / shifting the decimals and it pulled in the 12%... I'm lost. What's gone whacky with the Custom format after shifting the decimals? It has been working fine. Thanks 12% 12% $ 0 12% 12% 12%
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.
show a due date using data from multiple columns
I have a spreadsheet in excel, such as the Table 1 below. For the 5 Due Date columns, I have conditional formatting set up to format the cells. See Image 1 for a list of rules applied to all Due Date columns. I'd like for another table to populate, showing only columns, Laboratory ID, Description, and any column that is highlighted per the conditional formatting rules. For example, I'd like the return table to look something like Table 2. Table 1. populated in cells G9:N12 ID Description Due Date 1 Due Date 2 Due Date 3 Due Date 4 Due Date 5 Out of Service? 1234 Instrument 1 11/17/2025 N/A 1/31/2027 3/11/2026 11/17/2027 FALSE 1235 Instrument 2 1/14/2026 2/17/2026 3/31/2027 1/23/2026 12/29/2027 TRUE Table 2. Conditional formatting rules applied to cells I9:M12 This Week = White font color, Red fill This Month = Red font color, Light Red fill Next Month = Dark Yellow font color, yellow fill Table 2. If today is 11/10/2025, the table will display columns ID, Description, and only column show for due dates within This Week: ID Description Due Date 1 1234 Instrument 1 11/17/2025I 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.
