Hello to everyone. I am creating a spreadsheet for work. Columns will have rankings of Very High to Very Low for end users to complete; would like to keep the cells as text responses but in the formula they would represent 1:5 with VH = 5 points and so on. However, I then want to create a formula to give an overall rating to those rankings. Please see attached and I can be contacted for more information, if needed. I welcome any help with this. I tried the COUNTIF but that only gave to me a SUM of the row across after successfully assigning a number value to each alphabet combination....not exactly what I needed, but close!
Kind regards,
Ny
Convert Text to Numbers - Copy.xlsx
Bookmarks