thedeadzeds
Active Member
- Joined
- Aug 16, 2011
- Messages
- 442
- Office Version
- 365
- Platform
- Windows
Hi Guys,
Column A contains data based on group. For example, A3 to A8 are all part of New Vehicles. I need to concatenate these if column B shows Y so I can split out these groups.
For example, the formula in C3 to C8 is =IF(B3="Y",CONCATENATE($A$2," ",A3),A3) whilst the formula in C11 to C16 is =IF(B11="Y",CONCATENATE($A$10," ",A11),A11) and so on
At the moment I need to change the formula as per above. The List in column A has 1000 entries so I'm hoping this can be done another way.
Hope this makes sense
Column A contains data based on group. For example, A3 to A8 are all part of New Vehicles. I need to concatenate these if column B shows Y so I can split out these groups.
For example, the formula in C3 to C8 is =IF(B3="Y",CONCATENATE($A$2," ",A3),A3) whilst the formula in C11 to C16 is =IF(B11="Y",CONCATENATE($A$10," ",A11),A11) and so on
At the moment I need to change the formula as per above. The List in column A has 1000 entries so I'm hoping this can be done another way.
Hope this makes sense
Type | Y or No | Concatenate |
New Vehicles | ||
Vehicles Sold | y | New Vehicles Vehicles Sold |
Vehicles Ordered | y | New Vehicles Vehicles Ordered |
Vehicle Sales | y | New Vehicles Vehicle Sales |
Vehicles Sold GP (VSB) | y | New Vehicles Vehicles Sold GP (VSB) |
Vehicles Sold GP | y | New Vehicles Vehicles Sold GP |
Avg Gross Profit/Vehicle | y | New Vehicles Avg Gross Profit/Vehicle |
Motability | ||
Vehicles Sold | y | Motability Vehicles Sold |
Vehicles Ordered | y | Motability Vehicles Ordered |
Vehicles Sold Sales | y | Motability Vehicles Sold Sales |
Motability Vehicles Sold GP (VSB) | y | Motability Motability Vehicles Sold GP (VSB) |
Vehicles Sold GP | y | Motability Vehicles Sold GP |
Avg Gross Profit/Vehicle | y | Motability Avg Gross Profit/Vehicle |
Demo/Wholesale | ||
Demo Conv & Wholesale Transf Vehicles Sold | y | Demo/Wholesale Demo Conv & Wholesale Transf Vehicles Sold |
Vehicles Ordered | y | Demo/Wholesale Vehicles Ordered |
Vehicle Sales | y | Demo/Wholesale Vehicle Sales |
Vehicles Sold GP (VSB) | y | Demo/Wholesale Vehicles Sold GP (VSB) |
Vehicles Sold GP | y | Demo/Wholesale Vehicles Sold GP |
Avg Gross Profit/Vehicle | y | Demo/Wholesale Avg Gross Profit/Vehicle |
Total Vehicle Sales | n | Total Vehicle Sales |
Total Vehicle Gross Profit | n | Total Vehicle Gross Profit |