LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 2
Default Search a range for instances of a text string, return neighboring cell values each ti

Please see attached worksheet. For each "nth" instance of a particular text string appearing in a range (a column), I'd like to return the value of the cell to it's left (in the same row).
Attached Files
File Type: zip Spreadsheet Problem.zip (7.0 KB, 86 views)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Nested formula to search a text string and return specific text Barbie Excel Worksheet Functions 10 February 21st 09 07:40 AM
HOW DO I GET A CELL TO RETURN A NEIGHBORING CELL'S VALUE des-sa Excel Worksheet Functions 6 May 7th 08 01:26 AM
return cell address of longest text string in a range Dave F[_2_] Excel Discussion (Misc queries) 2 July 12th 07 03:41 PM
Checking number of uniques instances of values in text string MikeCM Excel Programming 6 October 9th 06 07:20 PM
find instances & report neighboring values [email protected] Excel Discussion (Misc queries) 7 October 19th 05 07:33 PM


All times are GMT +1. The time now is 07:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"