The Power Loon
New Member
- Joined
- Feb 7, 2020
- Messages
- 34
- Office Version
- 365
- Platform
- Windows
I have an issue i'm trying to work out. Whenever the term "addon" is found in the Description column, I want its "Price" added in the Extra column where ever the Group ID is the same.
Below, you can see that $50.00 had been added in the Extra column for every row with the same GroupID as the "addon".
Unfortunately, I haven't been able to work out a functional formula. Is this even possible outside of VBA?
Below, you can see that $50.00 had been added in the Extra column for every row with the same GroupID as the "addon".
Description | Group ID | Price | Extra | |
product 1 | hhh | $3,467.00 | ||
addon | yyy | $50.00 |
| |
product 2 | yyy | $454.80 | $50.00 | |
product 3 | yyy | $67.99 | $50.00 | |
product 1 | kkk | $3,467.00 | ||
product 4 | kkk | $456.00 |
Unfortunately, I haven't been able to work out a functional formula. Is this even possible outside of VBA?