twistinginthewind
Board Regular
- Joined
- Jun 25, 2003
- Messages
- 119
I have a worksheet with Column A with 5 rows (three are blank) See below.
A
1 Test
2 {blank}
3 {blank}
4 {blank}
5 Test 2
What I would like is a formula I can put in column B that would tell me which row contains the next item in column A. so it would looks omthing like:
A B
1 Test 5
2 {blank}
3 {blank}
4 {blank}
5 Test 2
I want to be able to do this no matter how many blanks there are or how many items.
Any ideas?
A
1 Test
2 {blank}
3 {blank}
4 {blank}
5 Test 2
What I would like is a formula I can put in column B that would tell me which row contains the next item in column A. so it would looks omthing like:
A B
1 Test 5
2 {blank}
3 {blank}
4 {blank}
5 Test 2
I want to be able to do this no matter how many blanks there are or how many items.
Any ideas?