palaeontology
Active Member
- Joined
- May 12, 2017
- Messages
- 444
- Office Version
- 2016
- Platform
- Windows
I have the following values in the range BF54:DD54 ...
I'm currently using the following formula to return the same list of values into the range F54:BD54 ...
={IF(COLUMN(BF:BF)<=SUM(--($BF53:$DD53<>""))+1,INDEX($BF53:$DD53,0,SMALL(IF($BF53:$DD53<>"",COLUMN($BF53:$DD53)-1,""),COLUMN(F:F)-1)),"")}
however, it's returning a blank in every cell in that range.
Can anyone see where I've gone wrong with my formula ?
Please don't tell me I can use data validation or other methods to do the same ... I definitely want to use a formula for this, for reasons of my own.
Kind regards,
Chris
I'm currently using the following formula to return the same list of values into the range F54:BD54 ...
={IF(COLUMN(BF:BF)<=SUM(--($BF53:$DD53<>""))+1,INDEX($BF53:$DD53,0,SMALL(IF($BF53:$DD53<>"",COLUMN($BF53:$DD53)-1,""),COLUMN(F:F)-1)),"")}
however, it's returning a blank in every cell in that range.
Can anyone see where I've gone wrong with my formula ?
Please don't tell me I can use data validation or other methods to do the same ... I definitely want to use a formula for this, for reasons of my own.
Kind regards,
Chris