Forum Widgets
Latest Discussions
Inconsistent print settings
Hello, We have shared printers at work that have predefined black and white printing. This setting can be temporarily changed before sending the file to print and then the entire document is printed in color (for example a word document). But excel behaves differently. When we want to print for example 4 sheets from one excel document, the color printing setting is only reflected on the first sheet, not on the others (even if we have selected that we want to print the whole document) Is this correct behavior? How to prevent this behavior? Alternatively, how to simply set the same settings for all sheets in one excel document? We use office 365. Thank you
Office Scripts - How to use "RC" in a Script
Hello, I tried to use ROW(RC) in a conditionnal formula in an Office Script but the result is ROW('RC') and the formula doesn't work. If I use only ROW() my conditonnal formula doesn't work. How can I create a conditionnal formula that refers to an RC reference in Office Script ? Thank you, PS: I use french XL so it's LIGNE(LC) instead of ROW(RC). Arnaud (from France)
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.
