Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A count function or macro needed
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
A count function or macro needed
I cannot understand your question. What color? And what is "farthest digit back"
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
A count function or macro needed
The color is in the sample document, but I have reworded my request. Le me know if you need further information: The furthest digit back: each of the 3 cells being evaluated (R S an T) have single digit values which have occurred in previous R, S cells, but the value which last appeared in the earliest row is th value which the furthest back. I want the function to count how man rows since the last time that value last occurred. I now need a function that will count back all previous rows for th farthest digit back in the R, S and T cells and place it in the column. See sample below the N column has the correct 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 ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Needed Macro and Function Help | Excel Discussion (Misc queries) | |||
Detailed Function (or Macro) Needed... Help | Excel Worksheet Functions | |||
macro or function help needed for adding columns for values missin | Excel Discussion (Misc queries) | |||
HELP NEEDED FOR IF Function Inside a Macro | Excel Worksheet Functions | |||
PivotTable Macro Reverts to Count Function | Excel Worksheet Functions |