Braille Translator Challenge
Using the Braille Alphabet lookup table provided: Part 1 - convert the given phrase from Braille to words. Part 2 - convert the given phrase from words to Braille. ✅ Solutions should be in the form of a single-cell formula. ✅ Generalized Lambda functions are welcome, provided the function definitions are included with your solution. ✅ Keep in mind, the "best" solution is not necessarily the shortest... Strive for conciseness, if you wish; just don't let your solutions be ordinary. 😉 Good luck and have fun!
Copy Array N times with excel formula
Hello everyone, I am working on defining a rectangle using two points: the initial point and the end point. What I want to achieve is to subdivide the segments of the rectangle N times based on both the X and Y coordinates, and then get the coordinates of these points. The goal is to get these coordinates in two rows (I thought maybe an array should work in this case). I have managed to get arrays using the SEQUENCE command, but I'm having difficulty duplicating that array multiple times. Coordinate X =SEQUENCE(1;G4+1;C5;I4) Coordinate Y =SEQUENCE(1;H4+1;D5;J4) What I need now is to repeat these array N times. This is an example for these inputs; Coordinate X: {0,5,10,0,5,10,0,5,10,0,5,10,0,5,10,0,5,10} Coordinate Y: {0,0,0,2,2,2,4,4,4,6,6,6,8,8,8,10,10,10} As you can see, what I want is: For X coordinates, multiply the initial array {0,5,10} 5 (Y Subdivision)+1 times to get {0,5,10,0,5,10,0,5,10,0,5,10,0,5,10,0,5,10} For Y coordinates, repeat each number of the array {0,2,4,6,8,10} 2 (X Subdivision)+1 times getting {0,0,0,2,2,2,4,4,4,6,6,6,8,8,8,10,10,10} I've read some posts on this issue such as this one: https://techcommunity.microsoft.com/t5/excel/creating-a-dynamic-repeating-sequence-of-arrays/m-p/3407457 And while the solutions involved column arrays, I'm having trouble applying those solutions to row arrays. Any help would be greatly appreciated! Thanks in advance!Welcome to the Excel Community
The Excel Community is a place we've built for all of you. You can learn more about how to do something with Excel, discuss your work, and connect with experts that build and use the product. With over half a billion Excel customers, we want to engage with you in fundamentally different ways and the community is a starting point for that. Our community helps answer your product questions with responses from other knowledgeable community members. We love hearing feedback and feature requests from you which helps us build the best version of Excel ever. If you have found an outage or a bug please post at our Answers forum. We look forward to getting to know you! Sangeeta Mudnal & Olaf Hubel on behalf of the Excel Team
Autofill options are not appearing when I drag the cell
Hi, I want to drag cells down the same row. However, when I do it, it only repeats the same one, even though I select different dates, for example when selecting 09/04/19 & 10/04/19 and dragging them down, all the cells would have 09/04/19. As I drag the cells, autofill options do not appear, instead, I get the option for "quick analysis". Please help.
Missing Stock Jio Financial Services in Excel Stocks Data Type
Hi! The stock Jio Financial Services Limited listed on Mon 25-Aug-23 (NSE symbol: JIOFIN). But this is missing in Excel. When I enter JIOFIN.XNSE and try to convert to a Stocks Data type, it says not found. Kindly update your Stocks database. VSBigSpill: A 90‑Function Excel LAMBDA Library for Dynamic Arrays
What is BigSpill? BigSpill is an Excel LAMBDA library containing 90 functions across 10 categories, built from extensive experimentation with dynamic arrays. The goal is to provide elegant, efficient tools that make sheet‑level formulas easier to read, more modular, and more dynamic. The library includes a mix of: quality‑of‑life helpers essential primitives mid‑level operators developer‑level tools a few functions you might not expect to see in Excel Who is it for? Everyone. BigSpill aims to make complex operations more approachable and expressive. A few examples from the library: Pairwiseλ Staircaseλ Grainλ PolarGridλ Convolveλ Foldλ Tessellateλ Revealλ Knapsackλ Magnifyλ Traverseλ The repository includes full documentation and 11 sample workbooks so you can explore the functions without setup. If you’re interested in experimenting with dynamic arrays, or LAMBDA workflows, feel free to take a look. Feedback and suggestions are always welcome. I've attached 1 onboarding workbook. There are 10 more at the link below. GitHub: BigSpill
Data Triggers
I'm relatively new to spreadsheets and excel. I'm working with a spreadsheet for mileage allocation. The mileage is funded from a single source but allocated to several people. In the spreadsheet, is it possible for the alpha entry in, for instance, column "C" cause the data in column "B" to populate in columns "D", "E". or "F" depending on the entry in column "C"? Example. Can the mileage cash value that's populated in column "B" get sent to a cell in either columns "D", "E", or "F" according to the name inserted in column "C" Entry "John" would cause B to populate D; "Dave" would cause B to populate E and "Jane would cause B to populate F so I can tally each person's share of the mileage without having to re-enter that amount in each of the columns? Any help in this would be appreciated.
Sum of data across multiple columns & rows based on Criteria
I have a data set that ranges across multiple rows and columns. I am building a formula and looking to sum based on multiple criteria. I tried sumifs, however, that does not work. Below is my example using a hypothetical sumifs (keeping in mind, this does not work). Any suggestions on how to return my expected result would be greatly appreciated. =SUMIFS('Query Budget'!$C$10:$HV$1000,'Query Budget'!$A$10:$A$1000,F$1,'Query Budget'!$A$5:$HV$5,$D5)
