In my example i have a column with Names of signs we product in our sighshop and I need to be able to isolate similar named signs So say I need to return a a value if the cell is Bud Light and only Bud Light from the following:
Bud Light Platinum
Bud Light Lime
Bud Light NFL
Carried out over 100 times at random.
I am trying to dig out what signage and promotions cost.
Link to Google Sheet
Edited link hopefully it is useful now.
The above sheet is a sample of what I am trying to do.
The reasoning for this is to return how much we spend on signage from a particular printer based on Brand of Beer and the type of sign it is. There may be 1000 orders in a months time and the report generated by the system lumps everything together, thus the need to dig it all out and the randomness of it all.