You could probably keep your checkboxes and deal with this with VBA code (a
Macro) that would have to be written.

An option would be to add a column and put an X in it or leave it blank
instead of using the checkboxes and then filter the data to display only the
rows with an X in a column.

" wrote:

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