Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Macro for Beginners | Excel Worksheet Functions | |||
Manual for beginners -- Charts with Excel | Charts and Charting in Excel | |||
Excel Macros for Beginners | Excel Discussion (Misc queries) | |||
Saving an Excel Spreadsheet with a particular name - Beginners | Excel Programming | |||
Saving an Excel Spreadsheet with a particular name - Beginners | Excel Programming |