Hi,

Are there any formulas for excel that will allow values to be displayed if they are in multiple events. Using the example below, I would like a cell to display "Trucks" because it is under New and Junk.

Example:
Trucks New
Trucks New
Cars Old
SUVs Used
Trucks Junk


Thanks for the help!
Tee