byrow

I am trying to use Textsplit with byrow to return multiple results, but I am getting a CALC error. Ignore the name error. This is my personal computer. The ":" is the delimiter. AB1Product21800:940032400:250045#NAME?67Result I would...

Hello All, I am blocked with a formula trying to get the minimum of a list of values below each row of the considered value. Sorry, I am maybe not very clear it is not easy to phrase with words so I attached my case below, I am sure you will better understand. Thank you for your help...

I am preparing a cashflow model which has a column with years starting at say 2023 going on for several decades. I wish to make a periodic income in the adjacent column that starts in say 2025 then repeats every say 3 years. Could someone help construct a formula for this? The start year, the...

Hi everyone. Im trying to find the average of the top values of several- non continued ranges. see image for reference: What I need is being able to average the TOP value of range B4:B15 with the TOP (the ones in green) value of B17:28 and so on for the next following cells that are not in...

Hello, I am wanting to spill an xlookup of a maximum number but am hitting a #VALUE error. The basic format is: week cat rat intended result basic intent 2 34 16 cat =xlookup(max(b2:c7),$b$2:$c$7,$b$1:$c$1)) 3 48 24 cat 4 37 15 cat 5 25 40 rat 6 54 45 cat 7 38 39...