I have a worksheet in which many students have given their answers t
how many pieces of candy are in a jar. I am trying to figure out
formula that will allow me to find out who was right within 10 percen
of the actual number. Like if the actual number was 100 I want to fin
the people who entered numbers from 90-110. I am wondering if their i
an easier way than just typing in all the numbers between 90-110 in
filter.

Thanks

--
Message posted from http://www.ExcelForum.com