View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
smartin smartin is offline
external usenet poster
 
Posts: 915
Default putting peoples' ages in age groups...?

sherry wrote:
THANK YOU SO SO MUCH. By reading your formula, I'm assuming that I can also
use that for putting people into salary groups also. It just depends on what
I choose to type in Columns A & B on Sheet 2, correct? If so, this is (and
you are) a lifesaver!


Yes that will work the same way. Just make sure Sheet2 column A is
sorted ascending, and adjust the formula to accommodate the number of
rows you have in Sheet2.