Originally Posted by
daddylonglegs
Try this formula in C2 copied down
=LOOKUP(C2,INT(COUNT(C:C)/5)*{0,1,2,3,4}+1,{"A","B","C","D","E"})
This should give the distribution you want, e.g. for 248 records as per your example this will give 49 of each of A, B, C and D and 52 E grades.
Note that this distribution might vary if you have ties in column B because then you will have duplicate ranks but I would suggest that that would be better than giving different grades to 2 records with identical number of households....
Bookmarks