Hey, I am trying something with excel.. This is my desired result (of course entered manually for each cell)
I want to replicate this entirely with formulas .. In cell A1
The formula I tried did not give me the result as you can see with the highlighted in orange cells has different numbers
Is there a single formula and preferrably elegant formula that gives me what I need.?
Thank you one and all.. This is my first post..![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
![array.png](/board/proxy.php?image=http%3A%2F%2Fs16.postimg.org%2Fec4kr4did%2Farray.png&hash=5823a249149ac895c0d4175a44afd841)
I want to replicate this entirely with formulas .. In cell A1
Code:
=+IF(COLUMNS($A:A)>ROWS($1:1),COLUMNS($A:A)-1,IF(COLUMNS($A:A)=ROWS($1:1),0,ROWS($1:1)-1))
The formula I tried did not give me the result as you can see with the highlighted in orange cells has different numbers
![wrong_array.png](/board/proxy.php?image=http%3A%2F%2Fs16.postimg.org%2F6knusk9d1%2Fwrong_array.png&hash=dc2c241e9cbc4c513bfdd5dfa6b24068)
Is there a single formula and preferrably elegant formula that gives me what I need.?
Thank you one and all.. This is my first post..
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)