How to put brand names beside their products (if its a huge list of products). Quickest way please and through I know i can do it with sorting, alternative please.
Thanks!
View attachment MB.xlsx
Thanks!
View attachment MB.xlsx
Data Insertion - Quickest way
- Thread starter Exceler
- Start date
- Joined
- May 20, 2011
- Messages
- 1,518
- Reaction score
- 1
- Points
- 0
- Location
- Mississauga, Canada
- Excel Version(s)
- Excel 2016
If you can say that any iPhone is Apple, Galaxy is Samsung, and the rest are Nokia, then we can easily apply a formula... but if there are others (i.e. non-Galaxy branded Samsungs), then it would be more difficult. You would need a keyword table or something to lookup to find match.
- Joined
- May 20, 2011
- Messages
- 1,518
- Reaction score
- 1
- Points
- 0
- Location
- Mississauga, Canada
- Excel Version(s)
- Excel 2016
Try:
=IF(LEFT(A2,6)="iPhone","Apple",IF(LEFT(A2,6)="Galaxy","Samsung","Nokia"))
copied down
=IF(LEFT(A2,6)="iPhone","Apple",IF(LEFT(A2,6)="Galaxy","Samsung","Nokia"))
copied down
- Joined
- May 20, 2011
- Messages
- 1,518
- Reaction score
- 1
- Points
- 0
- Location
- Mississauga, Canada
- Excel Version(s)
- Excel 2016
It's actually part of LEFT(A2,6) which means extract the left 6 characters of A2...
