Combine specific words into a single word only if all are present

a few questions
- do the fruit always come in the same order? e.g. would the input ever be 'orange, banana, apple' and still be replaced with 'fruit'?
- are they entered into the same cell, or spread across several cells? helpful if you can mock this up an example workbook
- for the last example, excel would need some logic to determine if the output should be 'tree fruit, grapes' or 'fruit, pineapple, grapes' as both outputs are technically valid

Thank you for the response. I can mock this up when i get to work.

- the fruit are always in different orders.
- they are input into different cells, however i can change it to be in the same cell if thatll make it easier.
- ok ok thank you. I would need logic then because i only ever one each argument to be used once and i want them to be in the output requiring the larger input

I can't think of any smart formulas that will do it in one go.

Attached is a rough-cut approach using lookup tables and helper columns. It can be heavily optimised, especially if you can use Office 365 instead of 2010, but should give some inspiration to a possible solution.