View Single Post
  #1   Report Post  
Stephen
 
Posts: n/a
Default Eliminate empty cells in data range

Hi Everyone! I'm using a MIN function to find the lowest value in a set of 10
values that I am downloading from the internet. The problem is, the data will
sometimes have an empty cell before the next set of data. I want to find the
lowest value of the last ten values. If I just use a range, it will sometimes
be 8, 9, or 10 values as the spaces change with the download from the
internet?
Is there any way to find the lowest number in a set of 10 values if there
are empty cells involved? Thank you.

--
Thanks!

Stephen