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 tab
Count 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:
Struggeling 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!Conditional 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!
Drop 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.
Assistance 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, VipinSeveral 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. Fred
