Finding a lowest value

[Ric F]

Good afternoon!

I have a spreadsheet that has frequencies listed where "Twice-A-Week" is the lowest score, then "Weekly" followed by "Monthly". I am looking for a way to determine based on row 1 the lowest value and have it populate in the 3rd row. In this case Twice-A-Week is located in the 5th column, so it should populate in cell B3.

Testing Frequency	Weekly	Weekly	Monthly	Twice-A-Week	Monthly	Monthly
Lowest Score	Twice-A-Week

Thanks for your help!

 

[Eric W]

Try:

=IF(COUNTIF(B1:G1,"Twice-a-Week"),"Twice-a-week",IF(COUNTIF(B1:G1,"Weekly"),"Weekly",IF(COUNTIF(B1:G1,"Monthly"),"Monthly","")))

 

[Ric F]

Perfect!! Thanks for the assist Eric!

 

[Eric W]

Happy to help! Thanks for the feedback!