Forum Widgets
Latest Discussions
Formula Help Required
Good Morning, I have started creating a sheet which works out transport weight and packaging required based on orders from our customer. I am after a formula to look at the Packaging Type and the quantities required and compile a packaging order list. The sheet would then tell me how many H Lids etc and then how many R lids etc. Sheet attached. I am looking to put the formula in boxes B27 to E30. Cheers
Need help reversing a formula
I'm trying to create a formula that will take a price from one cell and convert it to a letter code. I found a formula that does the opposite, it takes a letter code and converts it to a price. The pricing code is PATHFINDER (whereas P=1, A=2, T=3, H=4, F=5, I=6, N=7, D=8, E=9, and R=0) So, $12.45 would be PAHF, $5.60 would be FIR, etc. Here is the formula I used to convert a letter code to prices. =LET(l, LEN(C3), letters, MID(C3, SEQUENCE(l), 1), numbers, CONCAT(SWITCH(letters, "P", 1, "A", 2, "T", 3, "H", 4, "F", 5, "I", 6, "N", 7, "D", 8, "E", 9, "R", 0)), numbers / 100) In this formula, C3 had the text "PAHF" and the formula produced $12.45. Please help me find a way to take a price and convert it to the letter code instead (the opposite of what I did, essentially).
Need some help with pulling data from a table
So, I'm having a bit of trouble pulling a list of names from one table, onto another table. I have a table on a worksheet named 'I', where all my data and info is, and the table is named 'Shops'. In that table, are all the shops names, and below each shop is all the employee's from that shop. I have another table on another worksheet named 'Store'. I haven't named that table yet (do I need to?). Above that table, in cell D1, is a dropdown list, which is used to select the shop from the Shops table, and I'm trying to figure out how to populate cells A5 to A24 on the Store sheet, with the employee names from the Shops table, dependant on which shop was selected in the dropdown list. I have included a couple of screenshots, in the hopes that they will help. Any help on this would be greatly appreciated! Ignore the sizing of some of these cells, as it's due to data below that needed resizing.
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:Formula Help required - Believe it will be an IF function
Good Afternoon, I am creating a spreadsheet to export data out of an report for part number and quantities. I need a formula that searches for the part number then picks up the quantity next to the part number and fills it out in the box. Spreadsheet attached for reference. I want the formula to be in column B. Find the part number in column L and pick up the quantity from M and put it into the right box in column B based on the part number in column A.
