Thread: If cell has one value, go to adjacent cell and count
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lost in Microbiology
 
Posts: n/a
Default If cell has one value, go to adjacent cell and count
I have an imported text file (roughly 30,000lines). What I need is to see if
a column has the value "SAUR" and if so, count the columns with "S" in the
next 7 rows below it and 2 columns to the right.
Reply With QuoteReply With Quote