Match Last Occurrence of two numbers and Count to Previous Occurence

Hi Max & Biff,

Thank you for ongoing assistance.

Thanks for email attachment - will try amendments and post back in
Newsgroup.

Regards,
Sam

--
Message posted via http://www.officekb.com

Hi Max & Biff,

Biff's solution with the amendment using the TEXT Function worked well.

Max, I am also trying your solution and thank you for creating the
worksheet with the TEXT Function amendments to Biff's solution -
appreciated.

Thank you very much for all the help and your time.

Regards,
Sam

--
Message posted via http://www.officekb.com

You're welcome, Sam !
Glad to hear you got what you wanted
Thanks for the feedback ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik atyahoodotcom
----
"Sam via OfficeKB.com" wrote in message
...
Hi Max & Biff,

Biff's solution with the amendment using the TEXT Function worked well.

Max, I am also trying your solution and thank you for creating the
worksheet with the TEXT Function amendments to Biff's solution -
appreciated.

Thank you very much for all the help and your time.

Regards,
Sam

--
Message posted via http://www.officekb.com

.. There's a slight advantage in my suggested set-up g: It enables you
to
enter the paired inputs in Sheet2's cols A and B in any order, and also
the
source data in Sheet1 need not be in ascending sequence [on a per row
basis]
as well ..

And the paired inputs in Sheet2's cols A and B need not be consecutive
numbers either, for example you could retrieve the results for say: 51, 79
or 73, 59 etc
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik atyahoodotcom
----