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. CheersElliotDTJan 15, 2025Copper Contributor8Views0likes1CommentNeed 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).PandalawniJan 15, 2025Occasional Reader13Views0likes2CommentsNeed 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.SolvedWriggsJan 14, 2025Occasional Reader31Views0likes1Comment- SkeeterJan 14, 2025Occasional Reader10Views0likes1Comment
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:JoeUser2004Jan 14, 2025Bronze Contributor39Views0likes2Comments- rclangerJan 14, 2025Copper Contributor9.8KViews0likes4Comments
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.ElliotDTJan 14, 2025Copper Contributor16Views0likes1CommentExcel formula required
Hi, I am looking for a formula that would do a sum of the individual items on the workbook. They are not well arranged but the workbook is in use that way. I have provided a sample file with the expected results.SolvedA_SIRATJan 14, 2025Iron Contributor121Views0likes9Comments
Resources
Tags
- Excel41,980 Topics
- Formulas and Functions24,332 Topics
- Macros and VBA6,323 Topics
- office 3655,895 Topics
- Excel on Mac2,603 Topics
- BI & Data Analysis2,313 Topics
- Excel for web1,866 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,602 Topics