A | B | C | D | E | F | G | H | I | J | K | L | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | What | Formula | Result | 4 | 6 | 9 | 100 | XXX | ||||
2 | VALUE in last column in row1 | =LOOKUP(2,1/(1:1<>""),1:1) | XXX | |||||||||
3 | CELL reference (array formula) | {=ADDRESS(1,MAX(IF(1:1=LOOKUP(2,1/(1:1<>""),1:1),COLUMN(1:1)-MIN(COLUMN(1:1))+1)),4)} | L1 | |||||||||
4 | COLUMN no (array formula) | {=MAX(IF(1:1=LOOKUP(2,1/(1:1<>""),1:1),COLUMN(1:1)-MIN(COLUMN(1:1))+1))} | 12 |
Sheet: Sheet11 |
Hi,
In column range A-Z, row 1, there are cell values in E1, M1, Y1, the rest are blank. What functions can I use to determine the far most right column containing any value, in this case Y?