Hi bj,

Thank you very much for reply and assistance. Your Formula does the job.
Great!

=LARGE(ROW(C2:C100)*(C2:C100=C3:C101)*(C2:C101<" "),2)

corrected typo in the last range
=LARGE(ROW(C2:C100)*(C2:C100=C3:C101)*(C2:C100<"" ),2)

However, can you provide a version using the actual Dynamic Name "Data",
rather than the column and row references. Further assistance appreciated.

Cheers,
Sam

bj wrote:
try
=LARGE(ROW(C2:C100)*(C2:C100=C3:C101)*(C2:C101<" "),2)
entered as an array control-shift-enter
change the bottom if 100(101) is not enough
to find the last instead of the penultimate one use 1 instead for the end
number

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