search upwards in a spreadsheet column for next previous occurance

**r.coon** · 04-01-2011, 09:20 PM

I am using MS Office 2000 5.0 and Excel 2000 9.0

I want to search upwards in a spreadsheet column for next previous occurance only of whatever is entered (or selected by data validation) in a given cell.

**MarvinP** · 04-02-2011, 12:06 AM

Hi r.coon,

A quick internet search found this article.
http://thedailyreviewer.com/office/v...mand-112440965

I never knew I could Shift+Click on the Next button and it would look for previous.

Excel has so much stuff in it, how can any of us know it all?

Does it help?

**r.coon** · 04-05-2011, 01:35 AM

Thanks for the link, it may prove useful. I want to use a formula to find next previous occurance of text, then do some computation between cells associated with those two text occurances. Therefore I need to use the formula answer not the keystroke answer, but I'm not sure I understood the formula answer. It seemed it was written in shorthand assuming the reader was already familiar with the concept.