Hi Folks
ME again!
I thought this one would be easy but not having much luck....
So in Column A i want to key in a figure which Column B will read and give it a one of the following 5 groups (Blue 1-10, Black 11-50, Red 51-100, Yellow 100-200, Green 200+)
For example in Column A if i key in number 17, Column B will return Black 11-50
Now is there an easy way if i key in 100 entries on column A, to create a table which will count how many there are in each catagory group?
So i will get
Blue 1-10 = 15,
Black 11-50 = 22 ....
and so forth..
thanks :-)
Nick
Bookmarks