Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have an array with 500+ elements. Assume elements 100, 200, 300, and 400
are equal to 'Sue'. For each occurrence of Sue, I want to find the row number for the next occurrence and for the previous occurrence. At 100, I get 200 and 'none'. At 200, I get 300 and 100. But when I get to 300, I get 400 and 100, altho I want 400 and 200. When I am at 300, is there some way to have the search start at 299 and search backwards so that the first match it comes to is at 200? -- Bill @ UAMS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MATCH function | Excel Worksheet Functions | |||
Match function selecting first value it matches on exactly | Excel Worksheet Functions | |||
Need Formula or Function to calculate Margin (reverse of Percent a | Excel Worksheet Functions | |||
Need help on index and match function | Excel Worksheet Functions | |||
Offset, indirect, match function limitation on linked worksheets. | Excel Worksheet Functions |