Roy_Excel_Island_Apps
Board Regular
- Joined
- Oct 9, 2018
- Messages
- 68
- Office Version
- 365
- Platform
- Windows
Hi guys,
thanks for helping me out!
Example: There are values in multiple columns in row 1. I need a formula that returns the first value in that row.
Therefore I found this formula that works:
=INDEX(1:1;MATCH(TRUE;INDEX(ISNUMBER(1:1);0);0))
But now I need a formula that returns the SECOND value in this row. How do I get it? I will also need a formula to get the 3rde, 4th, ... value in a row.
Thanks in advance!
Roy
thanks for helping me out!
Example: There are values in multiple columns in row 1. I need a formula that returns the first value in that row.
Therefore I found this formula that works:
=INDEX(1:1;MATCH(TRUE;INDEX(ISNUMBER(1:1);0);0))
But now I need a formula that returns the SECOND value in this row. How do I get it? I will also need a formula to get the 3rde, 4th, ... value in a row.
Thanks in advance!
Roy