count numbers of delays from last lottery draw

  • Thread starter Thread starter Moti
  • Start date Start date
M

Moti

Dear Sir/Madam,
I would like to be advised and given some
specific formula to solve my problem. I have created a database with
some lottery draws from specific dates of this year. Unfortuately I am
enable to work out the formula needed to count the number of delays
from the last draw. For example: in the database attached the numbers
extracted from the first draw are written from the cells B3 to G3 and
downwards collectively as the number of draws increases. From cells I3
to N3 and downwards the number of delays from the last draw are
represented manually until I17 to N17. I would appreciate a given
formula to work out the number of delays automatically with the formula
to save up some time!

I will be waiting for your response desperately.
thanking you
MOTI.

Attachment filename: a-tip.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=552870
 
Maybe a one-glance "position map" might better serve the intent(s) <g> ?
(I don't have a direct suggestion to your post)

Try this set-up:

In a new sheet, say "Hoja2"

Put in

B1: =COLUMN()-1
Copy B1 across to AX1
[This sets up all the numbers: 1 ... 49 as col headers]

A2: =Hoja1!A3
Copy A2 down to A31

Select B2:AX2

Put in the formula bar:

=IF(Hoja1!B3=$B$1:$AX$1,Hoja1!B3,IF(Hoja1!C3=$B$1:$AX$1,Hoja1!C3,IF(Hoja1!D3
=$B$1:$AX$1,Hoja1!D3,IF(Hoja1!E3=$B$1:$AX$1,Hoja1!E3,IF(Hoja1!F3=$B$1:$AX$1,
Hoja1!F3,IF(Hoja1!G3=$B$1:$AX$1,Hoja1!G3,""))))))

Array-enter the formula (Hold down CTRL+SHIFT and press ENTER)

The same formula will appear in each cell in B2:AX2, within curly braces { }
inserted by Excel

With B2:AX2 selected, copy down to AX31

In B2:AX31 will be the lottery results from sheet: Hoja1
but with the numbers re-arranged nicely under the respective columns

... and this would, IMO, provide a one-glance "position map" of all the
lottery results thus far ..

The "map" is easily extendable for continual tracking / updates
by copying down the formulas in cols A and in cols B to AX

Good luck !
 
Dear Max,
Thank you very much for your reply. It was really ver
kind of you but it didn't quite work out becuase the solution you gav
to me i knew how to do it. What i was looking for actually was
formula for my question. I attached a new zip file with a more clea
example then before. If you can solve it i would be really greatful t
you.
Thank you very much for you collaboration and sorry for an
inconvenience.
Rgds
Moti. :

Attachment filename: tip.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=55323
 
You're welcome, Moti.
Think I got you the first time round
As mentioned in my response, I don't have a suggestion

( btw, think the link in your post below is not working ..)
 
Dear Max,
Could you please explain me how to post this messag
direct to newsgroup and from wich location.

Thanx
mot
 
Here's some often quoted useful links / responses ..

A) Hints And Tips For New Posters In The Excel Newsgroups
(Chip Pearson's site)

http://www.cpearson.com/excel/newposte.htm

Please note especially points 9 and 12 ...
9 Don't attach a workbook to your message.
12. Please post messages in "plain-text" format, without formatting. No
HTML....

------
B) From: Dave Peterson ([email protected])
Subject: Re: Searching newsgroups
Newsgroups: microsoft.public.excel.setup
Date: 2003-06-09 16:52:43 PST

First, if you're going to spend time in these newsgroups, you may want to
dump
the web based interface (CDO) and connect directly to the MS Servers.

If you have Outlook Express installed, try clicking on these links (or copy
and
paste into MSIE).

news://msnews.microsoft.com/microsoft.public.excel.setup
news://msnews.microsoft.com/microsoft.public.excel.misc
news://msnews.microsoft.com/microsoft.public.excel.worksheet.functions
news://msnews.microsoft.com/microsoft.public.excel.newusers

(You can always connect to more later)

Here are some links that explain it better:

Chip Pearson has some notes written by Leonard Meads at:
http://www.cpearson.com/excel/DirectConnect.htm

David McRitchie's notes at:
http://www.mvps.org/dmcritchie/excel/xlnews.htm
http://www.mvps.org/dmcritchie/excel/oe6.htm

Tushar Mehta's notes at:
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.htm

And if you're looking for old posts:

Or you can use google (maybe a few hours behind) to search for stuff you've
posted (and find the replies, too)

http://groups.google.com/advanced_group_search
(see David McRitchie's not below)

Ron de Bruin has an excel addin that you may like:
http://www.rondebruin.nl/Google.htm
 
Hi everybody,
if anybody can help out with the formula ia
looking for: to count the number of delays from the last lottery draw
I would be very grateful! Nobody has yet answered my question don'
think it's that tough either!!

thanx
moti;
 
Back
Top