Following the latest entry and the past 2 entries

**khank** · 06-13-2011, 12:51 PM

See attached.

In columns Y1 through AE5 I'm trying to breakout numbers of the current and past two entries for particular drawings.

The problem is these update alternately on a daily basis, so I need to "follow" that particular number of the "particular" drawing only a couple of days.

The latest drawing is three numbers the past two are only one number each.

Any suggestions?

**NBVC** · 06-13-2011, 01:34 PM

Are the numbers already in that range the expected values?

I am not following what you need and where the numbers will come from?

**khank** · 06-13-2011, 01:52 PM

Yes. Remember those values change daily depending on which drawing. I'm only looking to capture the "latest" three digits and the past 2 drawings "first" digit "under" the appropriate drawing time.

The latest numbers are picked up from Column B through M.

**NBVC** · 06-13-2011, 02:15 PM

In Y1 you currently have =O21... than seems to be an "evening" cell, no? Same with in Y2

Anyway.. try:

Y1: =LOOKUP(2,1/($M:$M=Y$6),$O:$O)
Y2: =LOOKUP(2,1/($M:$M=Y$6),$P:$P)
Y3: =LOOKUP(2,1/($M:$M=Y$6),$Q:$Q)
Y4: =INDEX($O:$O,MATCH(2,INDEX(1/($M:$M=Y$6),0))-2)
Y5: =INDEX($O:$O,MATCH(2,INDEX(1/($M:$M=Y$6),0))-4)

then copy Y1:Y5 and paste on AC1:AC5

**khank** · 06-13-2011, 02:39 PM

It works! I added several "false" numbers and "blam" it did it. Thank you. I'll close this Post, if over the next several days something happens I'll refer back to this post - I'm not expecting anything - just in case.

Again thanks for your help.

Ken