shyam
Active Member
- Joined
- Jul 18, 2005
- Messages
- 302
I have details as follows:
row 1 1
row 2 2
row 3 3
row 4 4
row 5 5
row 6 6
row 7 0
row 8 0
=LOOKUP(9.999999999999E+306,B:B)
With the above formula we can pick up the last entry, i.e. 0, but if the last entry in that column happens to be 0, then I need to pick up the previous entry which is not 0. The answer in the above problem would be 6 of row 6.
Would appreciate, if someone would revert back on the above.
Tks n rgds
shyam
row 1 1
row 2 2
row 3 3
row 4 4
row 5 5
row 6 6
row 7 0
row 8 0
=LOOKUP(9.999999999999E+306,B:B)
With the above formula we can pick up the last entry, i.e. 0, but if the last entry in that column happens to be 0, then I need to pick up the previous entry which is not 0. The answer in the above problem would be 6 of row 6.
Would appreciate, if someone would revert back on the above.
Tks n rgds
shyam