ok ok i figured out the answer to question 1... this one was actually
easy -- as long as the range on the countif statement includes all the
other values, it won't start the list over again... but any clues on
the second one?

jason gers
glaceau