View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] adambush4242@hotmail.com is offline
external usenet poster
 
Posts: 168
Default Making a Nonconsecutive range of data consecutive

I have a range of data of x and y values. Each point has a checkbox. If
this checkbox is checked on, I want to include the data in a linest type
function, however in order to do this the data has to be in consecutive rows.
I have about 15 points to choose from, and all or none of them can be used
at anytime. I've tried using if statments but it is much too complicated for
this. Any ideas?

Thanks

Adam Bush