Forum Widgets
Latest Discussions
If criteria is met in a certain column on the first sheet/tab of a workbook...
If criteria is met in a certain column on the first sheet/tab of a workbook, how can I have the entire row of info copied over onto a second sheet/tab? I'm trying to create a finance tab on a procurement workbook - and if column N is "Full Receipt," i want the entire row to copy itself onto the finance tabClinicalContributorJan 17, 2025Occasional Reader25Views0likes2CommentsHow to unprotect Excel sheet if forgot the password
I recently encountered a problem and hope to get your help. I set a protection password for an Excel file before. Now I want to modify some data, but I found that I forgot Excel password. I wonder if there is any way to remove the protection or unprotect Excel sheet password? If anyone knows a related solution or has had a similar experience, please share it, thank you very much! This file is very important to me, and there is a lot of work data in it. I have tried some methods found on the Internet, but none of them worked. It would be great if someone could provide some specific steps or recommend some tools.SolvedRuthDelbertJan 17, 2025Copper Contributor572KViews0likes50CommentsCount how many pairs of dice sum >= 7?
Please help me help someone in another forum. The problem: if we toss a pair of dice (6-sided), what is the probability that their sum is 7 or more? As I demonstrate below, the answer comes down to enumerating and counting the number of pairs with sum >= 7. Then, the probability is (#paired sums >= 7) / #pairs, where #pairs is #sides^2. (The answer is 21/36 = 7/12.) My question is: is there a formula that calculates #paired sums >= 7 without doing the enumeration manually or relying on VBA? I'm guessing that we can use Excel 365 features such as LAMBDA etc. But I know nothing of those features. And less importantly, for my benefit, is there an Excel 2010 formula, without relying on VBA? My "manual" solution:SolvedJoeUser2004Jan 17, 2025Bronze Contributor161Views0likes8Commentswavy lines and text
I'm getting wavy lines and text but only Excel it prints word and PDF fine any help would really be appreciated. MelvynMelvyn2Jan 17, 2025Copper Contributor21Views0likes1CommentStruggeling with multiple value drop down list - Indirect function
Hello! I work in a Warehouse, and we decided to move from Google Sheets to Excel web. I spend all day trying to figure out how to create drop down lists, but I got stuck. We have a three column classification, Group, Subgroup and Item, and all of this classification are related, so an Item is allocated inside and specific Subgroup, and this Subgroup to a specific Group. Even some Subgroups have the same name, but they belong to different Groups, sorry if this is messy. I managed to create the drop-down list for the Group, and the Subgroup but when it comes to the Item the Data validation doesn't allow me to introduce the right formula. For the Group I'm using a simple reference to a table with the different groups, for the Subgroup I'm using =INDIRECT(SUBSTITUTE($A2;" ";"_")), but for the Item I think I should use =INDIRECT(SUBSTITUTE($A2&"_"&$B2;" ";"_")) but it's not working... Maybe I'm overthinking this, and it's much easier than what I'm trying, but I'm complete stuck not understanding why does not work... Also, I have created a specific table for each of the items of each Group, and Sub-Group. I'm adding a link to the web excel if someone wants to look it up for a better understanding of the trouble: Inventory Thanks in advance!Berni_el_0rnitorrincoJan 16, 2025Occasional Reader37Views0likes3CommentsConditional Formatting with 4 Conditions
Hello! I am trying to get condition formatting to change the color of the row in my table based on values in 4 different columns. My goal is if the date in Column E is <=TODAY() and Column G = "In Work" as well as if Column I is <=TODAY() and Column H = "Yes" than it will highlight the row in red. I have attached a screenshot of the table below: What formula would I use to accomplish this? Any help will be greatly appreciated! Thanks!eclark1GATelesisJan 16, 2025Occasional Reader30Views0likes1CommentDrop down list Question
Hello,I have a Drop-down list in in Cell C2 with five options in it. L 1&2 L 3&4 L 5&6 L 7&8 L 9&10 Is it possible to auto fill other cells based on my selection? EX: if I select L 1&2 in cell C2 to auto fill cell C8 with 1 and cell C10 with 2. Or if I select L 5&6 to auto fill C8 with 5 and C10 with 6.Kirby LutzJan 16, 2025Copper Contributor18Views0likes1CommentAssistance Required for Excel Co-Authoring Sync Issue
Dear Microsoft Support Team, We are encountering an issue with Excel's co-authoring feature and would appreciate your assistance in resolving it. Problem Statement: We are using an Excel file with co-authoring enabled, allowing multiple users to work on the same file stored in OneDrive simultaneously. However, we have noticed a data syncing issue where two users working on the file are seeing different data. This discrepancy appears to stem from the syncing process. Could you please help us investigate and resolve this issue? If there are any recommended steps or troubleshooting methods we should follow, kindly share those as well. We look forward to your support. Best Regards, VipinvipinpanwarJan 16, 2025Copper Contributor22Views0likes2CommentsTRANSLATE() function not available in Excel
I would like to evaluate the new TRANSLATE function, but it is not available in my Excel. My Specs: Windows 11 ARM 64bit Excel version 2409 Insider Beta Channel OS and MS365 both fully updated.SolveddatamanjpJan 16, 2025Copper Contributor8.9KViews0likes8CommentsSeveral Problems with latest spreadsheet
I have been using Excel for a while. My latest spread sheet is having several problems, probably related. Numbers in the sheet do not appear in the formula bar Going along with this, the autosum does not add up a column and the formula also does not appear up top Thank you for any help. Probably something simple I did on the sheet. FreddrferdbJan 16, 2025Occasional Reader65Views0likes7Comments
Resources
Tags
- Excel42,005 Topics
- Formulas and Functions24,347 Topics
- Macros and VBA6,325 Topics
- office 3655,898 Topics
- Excel on Mac2,605 Topics
- BI & Data Analysis2,315 Topics
- Excel for web1,868 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,602 Topics