On one sheet I keep track of the lottery numbers every week. On anothe
sheet I try to keep the statistics of these numbers, like how man
times and how many drawings ago a number ........ The how many time
was no problem, with a COUNTIF....but the how many drawings ago
doesn't work. I tried an IF (sheet1!A1:A6="number",sheet2!A1+1
sheet2!=1. But then I get a circular reference statement. How do
proceed????

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