I have a spreadsheet which the user would enter a list of data points to be eventually plotted to a graph. There are 100 rows with the left most column containing a tick box for each row. i want the user to be able to tick 10 of the 100 boxes and have this data plotted to a graph in order from top of the list to bottom.
The tick boxes are linked to a column which display true of false. Ultimately i will have a column with 90 'FALSE' and 10 'TRUE' rows. The rows that are true could be in different places every time the sheet is used, including the first row containing true.
I want the data from the 10 true rows to be copied to a 10 row table (on the same sheet) and be plotted to a graph.
I had thought to number the true rows 1-10 from the top to the bottom which would make copying the data to the 10 row table simple.
However, i cannot get the numbering of these 'true' rows to work with a different start row each time. The closest i've managed was using the COUNTIF formula.
Can anyone help?