Excel: Get last data formula from column greater is than 1


Hi everyone, In the below sheet I have formulas and data fill in cells: B2:O20 and cells B21:O21 data comes from another source.

ABCDEFGHIJKLMNO
1Game1234567891011121314
2JR181
3JR191211
4JR20312
5JR2113
6JR2221
7JR2311
8JR24112
9JR25123
10JR2634
11JR27151
12JR28612
13JR293
14JR3014
15JR3111125
16JR3212121236
17JR33
18JR34
19JR35
20JR36
21461412137998761214

Data



I need formula for in cells B22:O22 that can get last data from each column is greater than 1 as shown below
ABCDEFGHIJKLMNO
1Game1234567891011121314
2JR181
3JR191211
4JR20312
5JR2113
6JR2221
7JR2311
8JR24112
9JR25123
10JR2634
11JR27151
12JR28612
13JR293
14JR3014
15JR3111125
16JR3212121236
17JR33
18JR34
19JR35
20JR36
21461412137998761214
2222236

Data Result



Thanks And Regards, Moti


This question generated 39 answers. To proceed to the answers, click here.

This thread is current as of March 09, 2014.


For more resources for Microsoft Excel