Last Column Result

[zinah]

Hi,

I have below table that I need to get the last column from every single column as showing in Result Column. Is there any formula suggestion I can use to accomplish this?

Last Column.xlsx
	A	B	C	D	E	F	G	H
1	Chain 1	Chain 2	Chain 3	Chain 4	Chain 5	Chain 6	Chain 7	Result
2	A	A1	A2	A3	A4	A5		A5
3	B	B1						B1
4	C	C1	C2	C3	C4	C5	C6	C6
5	D	D1	D2	D3				D3
6	E	E1	E2					E2
7	F	F1	F2	F3	F4			F4
Sheet1

 

[Anonymous1378]

Here's some of many options:

Book29
	A	B	C	D	E	F	G	H	I	J	K
1	Chain 1	Chain 2	Chain 3	Chain 4	Chain 5	Chain 6	Chain 7	Result
2	A	A1	A2	A3	A4	A5		A5	A5	A5	A5
3	B	B1						B1	B1	B1	B1
4	C	C1	C2	C3	C4	C5	C6	C6	C6	C6	C6
5	D	D1	D2	D3				D3	D3	D3	D3
6	E	E1	E2					E2	E2	E2	E2
7	F	F1	F2	F3	F4			F4	F4	F4	F4
Sheet2

Cell Formulas
Range	Formula
I2:I7	I2	=LOOKUP(2,1/(B2:G2<>""),B2:G2)
J2:J7	J2	=INDEX(B2:G2,XMATCH("*",B2:G2,2,-1))
K2:K7	K2	=INDEX(B2:G2,COUNTA(B2:G2))

 

[Fluff]

For the formula in col J I would suggest using

=INDEX(B2:G2,XMATCH("?*",B2:G2,2,-1))

incase the "blank" cells contain a formula that returns ""

 

[zinah]

Here's some of many options:

Book29
	A	B	C	D	E	F	G	H	I	J	K
1	Chain 1	Chain 2	Chain 3	Chain 4	Chain 5	Chain 6	Chain 7	Result
2	A	A1	A2	A3	A4	A5		A5	A5	A5	A5
3	B	B1						B1	B1	B1	B1
4	C	C1	C2	C3	C4	C5	C6	C6	C6	C6	C6
5	D	D1	D2	D3				D3	D3	D3	D3
6	E	E1	E2					E2	E2	E2	E2
7	F	F1	F2	F3	F4			F4	F4	F4	F4
Sheet2

Cell Formulas
Range	Formula
I2:I7	I2	=LOOKUP(2,1/(B2:G2<>""),B2:G2)
J2:J7	J2	=INDEX(B2:G2,XMATCH("*",B2:G2,2,-1))
K2:K7	K2	=INDEX(B2:G2,COUNTA(B2:G2))

Wow, all of these formula are amazing and I learned something new today! Thank you so much for your great support!

 

[zinah]

For the formula in col J I would suggest using

=INDEX(B2:G2,XMATCH("?*",B2:G2,2,-1))

incase the "blank" cells contain a formula that returns ""

that also worked! thank you for your usual support

 

[Fluff]

Glad we could help & thanks for the feedback.