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..

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

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..
