Morning guys,
If I have a colum say i2 to i20, and each cell contains one of three possible data values, is there a way to have a KEY at the side of the sheet to display the volume of each value in each cell.
e.g. colums I1 to I30 are written as :
yes
maybe
no
no
no
maybe
yes
yes
yes
maybe
.. etc.
I want a key to tell me how many YES', No's and Maybe's there are, which will also auto update when I change a value from one value to any of the other two.
Any ideas boys?
Social Networking Bookmarks