Hi!

OK.

Assume your table is in the range A20:I480.

Use a cell to hold the numbers you're looking for, say A1:

A1 = 7273

In a helper column, say column J, in J20 enter this
formula and copy down to J480. (or, just double click the
fill handle)

=IF(ISNUMBER(SEARCH
(A$1,A20&B20&C20&D20&E20&F20&G20&H20&I20)),ROW()," ")

Then, to find the number of rows between the last instance
and the previous instance:

=LARGE(J20:J480,1)-LARGE(J20:J480,2)-1

Biff

-----Original Message-----
Hi Biff,

Sorry, yes it is a typo. Should be 72 AND 73 LAST
Appear=ROW94 Previous
Appear=ROW80. The numbers will always be consecutive.

Regards,
Sam

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