Formula help please

[YoshiPeanut]

Hello, first time I have posted and need some help please. I have a table with 10 questions and people can choose from a drop down to say if a question is Critical, Essential or Recommended so I could end up with 3 Critical, 4 Essential and 3 Recommended etc. On a summary table I then want to show that if someone chooses at least one Critical from the 10 questions, Critical will show on the summary. If they don't choose any Critical but at least one Essential then Essential is shown on the summary etc. Is this possible? Thanks in advance.

 

[AlanY]

try this

Excel 2013/2016
	A	B
1	Recommended	Critical
2	Recommended
3	Essential
4	Essential
5	Critical
6	Critical
7	Recommended
8	Critical
9	Critical
10	Recommended
Sheet3

Cell Formulas
Range	Formula
B1	=IF(COUNTIF(A1:A10,"Critical")>=1,"Critical",IF(COUNTIF(A1:A10,"Essential")>=1,"Essential",""))

 

[YoshiPeanut]

Brilliant!! Thank you so much. I was trying all sorts and making it far too complicated.

 

[AlanY]

you're welcome