Im really not all that excel-savvy and ive been trying so many different options for my problem...

Basically i have a column which has 10 cells with drop down options i can select from of:

- N/A
- Not Achieved
- Progressing
- Addressed
- Strength

I basically want a formula that can tell me if at least one of the cells has Not Achieved selected, it should return this as the overall result. If there is no Not Achieved in the cells but there is more than one Progressing, it should return the result Progressing and so on and so forth so basically the overall result always chooses the least desirable selection starting from Not Achieved and going right up to Strength. So for the outcome to be Strength, all 10 cells would need to have Strength selected.

I hope that makes sense!

Any direction would be immensely appreciated!!