Fruit | # | Total |
Apple | 2 | 8 |
Apple | 6 | NO VALUE |
Orange | 7 | 7 |
Apple | 9 | 9 |
Banana | 1 | 15 |
Banana<strike></strike> | 10 | NO VALUE<strike></strike> |
Banana<strike></strike> | 4 | NO VALUE<strike></strike> |
<tbody>
</tbody>
How do I consolidate a column but only if they're in consecutive order? I can't just use the consolidate feature because that will total all of the apples but I only want to total them if they come right in a row. Thanks!