Book2 | ||||||
---|---|---|---|---|---|---|
H | I | J | K | |||
1 | ||||||
2 | 5 | |||||
3 | 3 | |||||
4 | rake | hose | ||||
5 | broom | |||||
6 | 9 | |||||
7 | shovel | |||||
8 | ||||||
9 | 13 | |||||
10 | trimmer | |||||
11 | 22 | |||||
12 | 132 | |||||
13 | hose | |||||
Sheet3 |
On 2002-10-11 15:51, Yogi Anand wrote:
Hi fascsam:
Welcome to the Board!
You can use the MATCH and INDEX functions to get the last item in a list. See the worksheet simulation ...</SPAN>
Book2
H I J K 1 2 5 3 3 4 rake hose 5 broom 6 9 7 shovel 8 9 13 10 trimmer 11 22 12 132 13 hose Sheet3
Perhps others can suggest a shorter formula -- but this one does work.
Regards!
Yogi