Hello
I have a table with 1000+ rows. One column is the Item Name. Each Item Name is unique, but will appear in 8 to 15 rows contiguous of data (before going to the next item name), the number of rows in each dataset can vary.
I need to apply a formula (LINEST, etc) to that only references each Item's set of data. So I need some formula help to make a cell reference that starts at the beginning and ends at the end of the Item's set of data.
Thanks
Derek
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
I have a table with 1000+ rows. One column is the Item Name. Each Item Name is unique, but will appear in 8 to 15 rows contiguous of data (before going to the next item name), the number of rows in each dataset can vary.
I need to apply a formula (LINEST, etc) to that only references each Item's set of data. So I need some formula help to make a cell reference that starts at the beginning and ends at the end of the Item's set of data.
Thanks
Derek
Item Name | Data 1 | Data 2 |
10L-101-1 | 20.0 | 1.75 |
10L-101-1 | 17.5 | 1.49 |
10L-101-1 | 15.0 | 1.24 |
10L-101-1 | 12.5 | 0.92 |
10L-101-1 | 10.0 | 0.63 |
10L-101-1 | 7.5 | 0.41 |
10L-101-1 | 5.0 | 0.24 |
10L-101-1 | 2.5 | 0.11 |
10L-101-1 | 0.0 | 0.00 |
10L-102-1 | 20.0 | 0.35 |
10L-102-1 | 17.5 | 0.30 |
10L-102-1 | 15.0 | 0.25 |
10L-102-1 | 12.5 | 0.23 |
10L-102-1 | 10.0 | 0.11 |
10L-102-1 | 7.5 | 0.07 |
10L-102-1 | 5.0 | 0.04 |
10L-102-1 | 2.5 | 0.01 |
10L-103-1 | 0.0 | 0.00 |
10L-103-1 | 20.0 | 1.75 |
10L-103-1 | 17.5 | 1.50 |
10L-103-1 | 15.0 | 1.27 |
10L-103-1 | 12.5 | 0.92 |
10L-103-1 | 10.0 | 0.62 |
10L-103-1 | 7.5 | 0.40 |
10L-103-1 | 5.0 | 0.23 |
10L-103-1 | 2.5 | 0.08 |
10L-103-1 | 0.0 | 0.00 |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>