Hello.
I have a formula to find unique values in a column. I fill this down to a row where it will never exceed. Therefore, I have a lot of blank values after the last unique value.
When I am doing a sumifs off these values, I use a wildcard to sum values based on the cell to the left. When I do this on my blank cells, it repeats basically the total value of the cell since it sums everything with *(blank)* as a wildcard.
I would like this to happen once, as it basically acts as a grand total value.
How do I prevent this from duplicating?
Ex. data:
<tbody>
</tbody>
The number of entries in col a will vary depending on what data I dump into the data tab, so I need the excess formulas and blanks. I just need the values in B and C to stop after one blank and not repeat, ie, show blank as well
I have a formula to find unique values in a column. I fill this down to a row where it will never exceed. Therefore, I have a lot of blank values after the last unique value.
When I am doing a sumifs off these values, I use a wildcard to sum values based on the cell to the left. When I do this on my blank cells, it repeats basically the total value of the cell since it sums everything with *(blank)* as a wildcard.
I would like this to happen once, as it basically acts as a grand total value.
How do I prevent this from duplicating?
Ex. data:
Color | Sales | % of total |
Black | 100 | 58.8 |
Red | 50 | 29.4 |
Grey | 20 | 17.8 |
(blank) | 170 | 100.0 |
(blank) | 170 | 100.0 |
(blank) | 170 | 100.0 |
(blank) | 170 | 100.0 |
(blank) | 170 | 100.0 |
(blank) | 170 | 100.0 |
<tbody>
</tbody>
The number of entries in col a will vary depending on what data I dump into the data tab, so I need the excess formulas and blanks. I just need the values in B and C to stop after one blank and not repeat, ie, show blank as well