Hi bj,

Think, I've got it:

=LARGE(ROW(Data)*(Data=OFFSET(Data,1,0))*(Data<"" ),2)

Cheers,
Sam

Sam wrote:
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

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 OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200708/1