View Single Post
  #1   Report Post  
John Chaffey
 
Posts: n/a
Default Is thr way in Excel to "find" all cells tht cntain spcfic value, .

Sorry about the spelling... had to make it fit.

I want to do what "edit - find" does, except print the resulting rows that
contain the cells it finds. Is there a way to do this? i.e., search for all
rows with "hello" in a cell in column "greeting", say, then hide all the
other rows except these.

Thank you for your time on this.