Hi, I'm very new to Excel and not really sure if I'm going about this the right way or not.
I have to do a task every day and it's very repetitive and boring, so just trying to speed it up!
In a column in a table I have to enter 'H' (for high) 'M' (for middle) or 'L' for low - for each cell in the column, 9 rows in height. Then I have to read back up and add up all the 'H', all the 'L' and all the 'M'. If there are 6 or more 'H' its considered 'H' overall, so that gets entered in a cell at the bottom and the cell turned blue. If it's got 6 or more 'L' in the column, it's 'L' overall and that gets entered in the bottom cell and it's turned red. If there are 6 'M', it's 'M' in the bottom and the cell turned white.
Then I have to do that for another 20 columns...
How can I automate this so I can type in the H L and M's and the last bit is calculated and done for me? I was thinking of assigning H as +1, L as -1 and M as zero and then adding up the result to see if it's plus 6 minus 6 or somewhere inbetween
Bookmarks