Formula help!
 

Hi - I have two columns as below:
A B
01/03/07 B1234
01/04/07 B1235
01/05/07 B1236
01/06/07

I need a formula that will find the last entry in column B and return the
date on the same row from column A, is this possible?

Thanks

Becks

Formula help!
 

One way where c has dates and b has strings
=INDEX(C3:C10,MATCH("zzzzzzzzz",D3:D10))

--
Don Guillett
SalesAid Software

"Becks" wrote in message
...
Hi - I have two columns as below:
A B
01/03/07 B1234
01/04/07 B1235
01/05/07 B1236
01/06/07

I need a formula that will find the last entry in column B and return the
date on the same row from column A, is this possible?

Thanks

Becks

Formula help!
 

Hi Beck
as shown on your sample, i assume that the columns A and B has data in
ascending order..
=LOOKUP(LOOKUP(2,1/(B1:B16<""),B1:B16),B1:B16,A1:A16)
u may get the date on column A that corrsponds to the last filled cell in
column B range.

--
*****
birds of the same feather flock together..



"Becks" wrote:

Hi - I have two columns as below:
A B
01/03/07 B1234
01/04/07 B1235
01/05/07 B1236
01/06/07

I need a formula that will find the last entry in column B and return the
date on the same row from column A, is this possible?

Thanks

Becks

Formula help!
 

Cheers Driller, that worked a treat!

Becks

"driller" wrote:

Hi Beck
as shown on your sample, i assume that the columns A and B has data in
ascending order..
=LOOKUP(LOOKUP(2,1/(B1:B16<""),B1:B16),B1:B16,A1:A16)
u may get the date on column A that corrsponds to the last filled cell in
column B range.

--
*****
birds of the same feather flock together..



"Becks" wrote:

Hi - I have two columns as below:
A B
01/03/07 B1234
01/04/07 B1235
01/05/07 B1236
01/06/07

I need a formula that will find the last entry in column B and return the
date on the same row from column A, is this possible?

Thanks

Becks

Formula help!
 

Hello,

=LOOKUP(2,1/NOT(ISBLANK(B1:B999)),A1:A999)

Regards,
Bernd

Formula help!
 

you're welcome
i've seen there are also other options you can please to consider..
regards
--
*****
birds of the same feather flock together..



"Becks" wrote:

Cheers Driller, that worked a treat!

Becks

"driller" wrote:

Hi Beck
as shown on your sample, i assume that the columns A and B has data in
ascending order..
=LOOKUP(LOOKUP(2,1/(B1:B16<""),B1:B16),B1:B16,A1:A16)
u may get the date on column A that corrsponds to the last filled cell in
column B range.

--
*****
birds of the same feather flock together..



"Becks" wrote:

Hi - I have two columns as below:
A B
01/03/07 B1234
01/04/07 B1235
01/05/07 B1236
01/06/07

I need a formula that will find the last entry in column B and return the
date on the same row from column A, is this possible?

Thanks

Becks