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. VSUsing Formulas (IFERROR?)
I am trying to figure out a way to use the same formula (or combined formulas we can use in each) that will return the % of change as either -100% if column B is 0 or 100% if column A is 0 but B is not. The formula we are using right now is IFERROR((-(E152-F152)/E152),"0.0"%) This returns any columns with errors as 0, but it also is returning the column that should be 100% as a 0. Is there another formula I can combine or a better one to use that will do this? 2026 Budgeted 2027 Proposed % of Change 6,565,464 - -100.0% - 140,388 0.0% - 50 0.0%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!
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)
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!
