Hi All,
I work for a TV manufacturer and I need help filtering out incoming tickets based on model series.
For example, the attachment below is a sample of tickets extracted to excel, I manually highlighted models of the same series to show what I mean.
I'm looking for a formula or a way of sorting where I can show modes of the same series. I'm currently using the contain option for text filters but it's not very efficient as I only get to select 2 sets of letters at a time.
I hope I've made it as clear as possible but please let me know if more info is needed.
I'm kind if Excel newbie but I'm really looking forward to knowing more so any help is appreciated.
Kind regards,
B
I work for a TV manufacturer and I need help filtering out incoming tickets based on model series.
For example, the attachment below is a sample of tickets extracted to excel, I manually highlighted models of the same series to show what I mean.
I'm looking for a formula or a way of sorting where I can show modes of the same series. I'm currently using the contain option for text filters but it's not very efficient as I only get to select 2 sets of letters at a time.
I hope I've made it as clear as possible but please let me know if more info is needed.
I'm kind if Excel newbie but I'm really looking forward to knowing more so any help is appreciated.
Kind regards,
B