I am doing a spread sheet for lotto numbers, and I require a formula that can tell me how many days since a number was last drawn. I am working with 2 work sheets, one has the Draw number, dates and balls drawn. Second work sheet has the frequency, most common, least common numbers and last time they were drawn.
lotto,word.docx
I have watched hours of excel you tube and read heaps of forums but cannot find anything that works.
Can some body help me PLLEEEASE.
Hello debrahilton
You can use AGGREGATE function to find the last date a number was drawn.....and subtract that from today to get the number of days, i.e. this formula in J4 for results worksheet, copied down column
=TODAY()-AGGREGATE(14,6,'Set For Life'!B$2:B$1000/('Set For Life'!C$2:J$1000=B4),1)
Format formula cell as number with no decimal places
That assumes up to 1000 rows of data, adjust as required
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks