The problem is that all your values in column B are "text" - they need to be numbers!
One way to fix: select B2:B60,left-click on the yellow alert and select "convert to number"
In fact I have fixed it in a revised version of your workbook (attached).
Last edited by GeoffW283; 01-28-2019 at 08:28 PM.
Thanks, stupid mistake on my end!
Another question (trying to look at another option of grouping this), if I wanted to take an average score rather than an absolute number, how would I go about that?
i.e. between 2.51 - 3.00, if the average is greater than "X" value then a red flag (rather than 3 items being selected).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks