Need Formula for Last Occurance

I need a formula or array that will look up the last time a specific thing occured.

A1:A1000 has the date it occured
B1:B1000 has the thing that occured

A1001 is where I want the formula or array to display the answer
B1001 will be the occurance I enter to be looked up

Thanks, John

Hi!

Array entered:

=MAX(IF(B1:B1000=B1001,A1:A1000))

Format as DATE

Biff

"Reignman" <Reignman.1sasia_1121576703.1491@excelforum-nospam.com> wrote in
message news:Reignman.1sasia_1121576703.1491@excelforum-nospam.com...
>
> I need a formula or array that will look up the last time a specific
> thing occured.
>
> A1:A1000 has the date it occured
> B1:B1000 has the thing that occured
>
> A1001 is where I want the formula or array to display the answer
> B1001 will be the occurance I enter to be looked up
>
> Thanks, John
>
>
> --
> Reignman
> ------------------------------------------------------------------------
> Reignman's Profile:
> http://www.excelforum.com/member.php...o&userid=21023
> View this thread: http://www.excelforum.com/showthread...hreadid=387810
>

Care to provide a tiny sample along with the expected result?

Reignman wrote:
> I need a formula or array that will look up the last time a specific
> thing occured.
>
> A1:A1000 has the date it occured
> B1:B1000 has the thing that occured
>
> A1001 is where I want the formula or array to display the answer
> B1001 will be the occurance I enter to be looked up
>
> Thanks, John
>
>

Hi!

Array entered:

=MAX(IF(B1:B1000=B1001,A1:A1000))

Format as DATE

Biff

"Reignman" <Reignman.1sasia_1121576703.1491@excelforum-nospam.com> wrote in
message news:Reignman.1sasia_1121576703.1491@excelforum-nospam.com...
>
> I need a formula or array that will look up the last time a specific
> thing occured.
>
> A1:A1000 has the date it occured
> B1:B1000 has the thing that occured
>
> A1001 is where I want the formula or array to display the answer
> B1001 will be the occurance I enter to be looked up
>
> Thanks, John
>
>
> --
> Reignman
> ------------------------------------------------------------------------
> Reignman's Profile:
> http://www.excelforum.com/member.php...o&userid=21023
> View this thread: http://www.excelforum.com/showthread...hreadid=387810
>

Care to provide a tiny sample along with the expected result?

Reignman wrote:
> I need a formula or array that will look up the last time a specific
> thing occured.
>
> A1:A1000 has the date it occured
> B1:B1000 has the thing that occured
>
> A1001 is where I want the formula or array to display the answer
> B1001 will be the occurance I enter to be looked up
>
> Thanks, John
>
>

Hi!

Array entered:

=MAX(IF(B1:B1000=B1001,A1:A1000))

Format as DATE

Biff

"Reignman" <Reignman.1sasia_1121576703.1491@excelforum-nospam.com> wrote in
message news:Reignman.1sasia_1121576703.1491@excelforum-nospam.com...
>
> I need a formula or array that will look up the last time a specific
> thing occured.
>
> A1:A1000 has the date it occured
> B1:B1000 has the thing that occured
>
> A1001 is where I want the formula or array to display the answer
> B1001 will be the occurance I enter to be looked up
>
> Thanks, John
>
>
> --
> Reignman
> ------------------------------------------------------------------------
> Reignman's Profile:
> http://www.excelforum.com/member.php...o&userid=21023
> View this thread: http://www.excelforum.com/showthread...hreadid=387810
>

Care to provide a tiny sample along with the expected result?

Reignman wrote:
> I need a formula or array that will look up the last time a specific
> thing occured.
>
> A1:A1000 has the date it occured
> B1:B1000 has the thing that occured
>
> A1001 is where I want the formula or array to display the answer
> B1001 will be the occurance I enter to be looked up
>
> Thanks, John
>
>

Hi!

Array entered:

=MAX(IF(B1:B1000=B1001,A1:A1000))

Format as DATE

Biff

"Reignman" <Reignman.1sasia_1121576703.1491@excelforum-nospam.com> wrote in
message news:Reignman.1sasia_1121576703.1491@excelforum-nospam.com...
>
> I need a formula or array that will look up the last time a specific
> thing occured.
>
> A1:A1000 has the date it occured
> B1:B1000 has the thing that occured
>
> A1001 is where I want the formula or array to display the answer
> B1001 will be the occurance I enter to be looked up
>
> Thanks, John
>
>
> --
> Reignman
> ------------------------------------------------------------------------
> Reignman's Profile:
> http://www.excelforum.com/member.php...o&userid=21023
> View this thread: http://www.excelforum.com/showthread...hreadid=387810
>

Care to provide a tiny sample along with the expected result?

Reignman wrote:
> I need a formula or array that will look up the last time a specific
> thing occured.
>
> A1:A1000 has the date it occured
> B1:B1000 has the thing that occured
>
> A1001 is where I want the formula or array to display the answer
> B1001 will be the occurance I enter to be looked up
>
> Thanks, John
>
>

Hi!

Array entered:

=MAX(IF(B1:B1000=B1001,A1:A1000))

Format as DATE

Biff

"Reignman" <Reignman.1sasia_1121576703.1491@excelforum-nospam.com> wrote in
message news:Reignman.1sasia_1121576703.1491@excelforum-nospam.com...
>
> I need a formula or array that will look up the last time a specific
> thing occured.
>
> A1:A1000 has the date it occured
> B1:B1000 has the thing that occured
>
> A1001 is where I want the formula or array to display the answer
> B1001 will be the occurance I enter to be looked up
>
> Thanks, John
>
>
> --
> Reignman
> ------------------------------------------------------------------------
> Reignman's Profile:
> http://www.excelforum.com/member.php...o&userid=21023
> View this thread: http://www.excelforum.com/showthread...hreadid=387810
>

Care to provide a tiny sample along with the expected result?

Reignman wrote:
> I need a formula or array that will look up the last time a specific
> thing occured.
>
> A1:A1000 has the date it occured
> B1:B1000 has the thing that occured
>
> A1001 is where I want the formula or array to display the answer
> B1001 will be the occurance I enter to be looked up
>
> Thanks, John
>
>

Hi!

Array entered:

=MAX(IF(B1:B1000=B1001,A1:A1000))

Format as DATE

Biff

"Reignman" <Reignman.1sasia_1121576703.1491@excelforum-nospam.com> wrote in
message news:Reignman.1sasia_1121576703.1491@excelforum-nospam.com...
>
> I need a formula or array that will look up the last time a specific
> thing occured.
>
> A1:A1000 has the date it occured
> B1:B1000 has the thing that occured
>
> A1001 is where I want the formula or array to display the answer
> B1001 will be the occurance I enter to be looked up
>
> Thanks, John
>
>
> --
> Reignman
> ------------------------------------------------------------------------
> Reignman's Profile:
> http://www.excelforum.com/member.php...o&userid=21023
> View this thread: http://www.excelforum.com/showthread...hreadid=387810
>

Care to provide a tiny sample along with the expected result?

Reignman wrote:
> I need a formula or array that will look up the last time a specific
> thing occured.
>
> A1:A1000 has the date it occured
> B1:B1000 has the thing that occured
>
> A1001 is where I want the formula or array to display the answer
> B1001 will be the occurance I enter to be looked up
>
> Thanks, John
>
>

Hi!

Array entered:

=MAX(IF(B1:B1000=B1001,A1:A1000))

Format as DATE

Biff

"Reignman" <Reignman.1sasia_1121576703.1491@excelforum-nospam.com> wrote in
message news:Reignman.1sasia_1121576703.1491@excelforum-nospam.com...
>
> I need a formula or array that will look up the last time a specific
> thing occured.
>
> A1:A1000 has the date it occured
> B1:B1000 has the thing that occured
>
> A1001 is where I want the formula or array to display the answer
> B1001 will be the occurance I enter to be looked up
>
> Thanks, John
>
>
> --
> Reignman
> ------------------------------------------------------------------------
> Reignman's Profile:
> http://www.excelforum.com/member.php...o&userid=21023
> View this thread: http://www.excelforum.com/showthread...hreadid=387810
>

Care to provide a tiny sample along with the expected result?

Reignman wrote:
> I need a formula or array that will look up the last time a specific
> thing occured.
>
> A1:A1000 has the date it occured
> B1:B1000 has the thing that occured
>
> A1001 is where I want the formula or array to display the answer
> B1001 will be the occurance I enter to be looked up
>
> Thanks, John
>
>

Care to provide a tiny sample along with the expected result?

Reignman wrote:
> I need a formula or array that will look up the last time a specific
> thing occured.
>
> A1:A1000 has the date it occured
> B1:B1000 has the thing that occured
>
> A1001 is where I want the formula or array to display the answer
> B1001 will be the occurance I enter to be looked up
>
> Thanks, John
>
>

Hi!

Array entered:

=MAX(IF(B1:B1000=B1001,A1:A1000))

Format as DATE

Biff

"Reignman" <Reignman.1sasia_1121576703.1491@excelforum-nospam.com> wrote in
message news:Reignman.1sasia_1121576703.1491@excelforum-nospam.com...
>
> I need a formula or array that will look up the last time a specific
> thing occured.
>
> A1:A1000 has the date it occured
> B1:B1000 has the thing that occured
>
> A1001 is where I want the formula or array to display the answer
> B1001 will be the occurance I enter to be looked up
>
> Thanks, John
>
>
> --
> Reignman
> ------------------------------------------------------------------------
> Reignman's Profile:
> http://www.excelforum.com/member.php...o&userid=21023
> View this thread: http://www.excelforum.com/showthread...hreadid=387810
>

Hi!

Array entered:

=MAX(IF(B1:B1000=B1001,A1:A1000))

Format as DATE

Biff

"Reignman" <Reignman.1sasia_1121576703.1491@excelforum-nospam.com> wrote in
message news:Reignman.1sasia_1121576703.1491@excelforum-nospam.com...
>
> I need a formula or array that will look up the last time a specific
> thing occured.
>
> A1:A1000 has the date it occured
> B1:B1000 has the thing that occured
>
> A1001 is where I want the formula or array to display the answer
> B1001 will be the occurance I enter to be looked up
>
> Thanks, John
>
>
> --
> Reignman
> ------------------------------------------------------------------------
> Reignman's Profile:
> http://www.excelforum.com/member.php...o&userid=21023
> View this thread: http://www.excelforum.com/showthread...hreadid=387810
>

Care to provide a tiny sample along with the expected result?

Reignman wrote:
> I need a formula or array that will look up the last time a specific
> thing occured.
>
> A1:A1000 has the date it occured
> B1:B1000 has the thing that occured
>
> A1001 is where I want the formula or array to display the answer
> B1001 will be the occurance I enter to be looked up
>
> Thanks, John
>
>

Hi!

Array entered:

=MAX(IF(B1:B1000=B1001,A1:A1000))

Format as DATE

Biff

"Reignman" <Reignman.1sasia_1121576703.1491@excelforum-nospam.com> wrote in
message news:Reignman.1sasia_1121576703.1491@excelforum-nospam.com...
>
> I need a formula or array that will look up the last time a specific
> thing occured.
>
> A1:A1000 has the date it occured
> B1:B1000 has the thing that occured
>
> A1001 is where I want the formula or array to display the answer
> B1001 will be the occurance I enter to be looked up
>
> Thanks, John
>
>
> --
> Reignman
> ------------------------------------------------------------------------
> Reignman's Profile:
> http://www.excelforum.com/member.php...o&userid=21023
> View this thread: http://www.excelforum.com/showthread...hreadid=387810
>

Care to provide a tiny sample along with the expected result?

Reignman wrote:
> I need a formula or array that will look up the last time a specific
> thing occured.
>
> A1:A1000 has the date it occured
> B1:B1000 has the thing that occured
>
> A1001 is where I want the formula or array to display the answer
> B1001 will be the occurance I enter to be looked up
>
> Thanks, John
>
>

Hi!

Array entered:

=MAX(IF(B1:B1000=B1001,A1:A1000))

Format as DATE

Biff

"Reignman" <Reignman.1sasia_1121576703.1491@excelforum-nospam.com> wrote in
message news:Reignman.1sasia_1121576703.1491@excelforum-nospam.com...
>
> I need a formula or array that will look up the last time a specific
> thing occured.
>
> A1:A1000 has the date it occured
> B1:B1000 has the thing that occured
>
> A1001 is where I want the formula or array to display the answer
> B1001 will be the occurance I enter to be looked up
>
> Thanks, John
>
>
> --
> Reignman
> ------------------------------------------------------------------------
> Reignman's Profile:
> http://www.excelforum.com/member.php...o&userid=21023
> View this thread: http://www.excelforum.com/showthread...hreadid=387810
>

Care to provide a tiny sample along with the expected result?

Reignman wrote:
> I need a formula or array that will look up the last time a specific
> thing occured.
>
> A1:A1000 has the date it occured
> B1:B1000 has the thing that occured
>
> A1001 is where I want the formula or array to display the answer
> B1001 will be the occurance I enter to be looked up
>
> Thanks, John
>
>

Hi!

Array entered:

=MAX(IF(B1:B1000=B1001,A1:A1000))

Format as DATE

Biff

"Reignman" <Reignman.1sasia_1121576703.1491@excelforum-nospam.com> wrote in
message news:Reignman.1sasia_1121576703.1491@excelforum-nospam.com...
>
> I need a formula or array that will look up the last time a specific
> thing occured.
>
> A1:A1000 has the date it occured
> B1:B1000 has the thing that occured
>
> A1001 is where I want the formula or array to display the answer
> B1001 will be the occurance I enter to be looked up
>
> Thanks, John
>
>
> --
> Reignman
> ------------------------------------------------------------------------
> Reignman's Profile:
> http://www.excelforum.com/member.php...o&userid=21023
> View this thread: http://www.excelforum.com/showthread...hreadid=387810
>

Care to provide a tiny sample along with the expected result?

Reignman wrote:
> I need a formula or array that will look up the last time a specific
> thing occured.
>
> A1:A1000 has the date it occured
> B1:B1000 has the thing that occured
>
> A1001 is where I want the formula or array to display the answer
> B1001 will be the occurance I enter to be looked up
>
> Thanks, John
>
>

Hi!

Array entered:

=MAX(IF(B1:B1000=B1001,A1:A1000))

Format as DATE

Biff

"Reignman" <Reignman.1sasia_1121576703.1491@excelforum-nospam.com> wrote in
message news:Reignman.1sasia_1121576703.1491@excelforum-nospam.com...
>
> I need a formula or array that will look up the last time a specific
> thing occured.
>
> A1:A1000 has the date it occured
> B1:B1000 has the thing that occured
>
> A1001 is where I want the formula or array to display the answer
> B1001 will be the occurance I enter to be looked up
>
> Thanks, John
>
>
> --
> Reignman
> ------------------------------------------------------------------------
> Reignman's Profile:
> http://www.excelforum.com/member.php...o&userid=21023
> View this thread: http://www.excelforum.com/showthread...hreadid=387810
>

Care to provide a tiny sample along with the expected result?

Reignman wrote:
> I need a formula or array that will look up the last time a specific
> thing occured.
>
> A1:A1000 has the date it occured
> B1:B1000 has the thing that occured
>
> A1001 is where I want the formula or array to display the answer
> B1001 will be the occurance I enter to be looked up
>
> Thanks, John
>
>