I now need a function that will count back all previous orange and blu
rows for the farthest digit back in the R, S and T cells and place i
in the N column. See sample below the yellow N column have the correc
answers:

Example:
.................R..S...T........N
row 11:....9...0...6
row 12:....7...5...7
row 13:....7...3...4
row 14:....4...0...9.......3
row 15:....0...5...6.......4

on row 14 the 0 and 9 are equally the farthest digits back,
at 3 rows.
on row 15 the 6 is the farthest digit back at 4 rows.

I would appreciate your help

+----------------------------------------------------------------
| Attachment filename: book1b.xls
|Download attachment: http://www.excelforum.com/attachment.php?postid=359749
+----------------------------------------------------------------

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com