faeryluv
New Member
- Joined
- Sep 1, 2018
- Messages
- 47
I'm using the Subtotal function, and that works good for what I'm doing, however, I don't need all the extra rows.
Without the Subtotal function, I'm manually adding up the duplicate orders and then deleting the extra rows.
Example
Row 1: route 1 item D4 order 50
Row 2: route 1 item D4 order 25
In this case, I manually replace "50" with "75", then I manually delete Row 2. I have thousands like that so it takes hours to do. I need a faster way.
Any advice is much appreciated!!
Without the Subtotal function, I'm manually adding up the duplicate orders and then deleting the extra rows.
Example
Row 1: route 1 item D4 order 50
Row 2: route 1 item D4 order 25
In this case, I manually replace "50" with "75", then I manually delete Row 2. I have thousands like that so it takes hours to do. I need a faster way.
Any advice is much appreciated!!
