View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tpeter tpeter is offline
external usenet poster
 
Posts: 74
Default Finding Cell that changes from a Positive to a Negitive number

I am looking for a function that will look threw either columes or rows and
find the cell that changes from a positive number to a negitive number. This
location will always change and once this cell is found I need to used it in
a function to check for linearity. I have looked thew the help and forum and
haven't really found anything that might work. Any help with possible
functions would be great.