Earliest date, blank cells...

**OlliTbb** · 10-23-2009, 05:41 AM

Hi!
Step I: I need to find the earliest date in a row (R3:T3). Some cells are blank, and some contain same dates.

Step II: I need to find the earliest date in a row (U3:Y3). Some cells are blank, and some cells have the same date. If the earliest date is in column U it should print the content of U1, if earliest date is in column V, it should print the content of V1, etc. If the earliest date is in column U and V it should print the content of U1 & V1, if the earliest date is in column V, W and Y it should print the content of V1 & W1 & Y1, etc.

I'm a real n00b in using excel, so it would be very nice if you could explain it in a very simple way ;-)

Answers solving my problem in a couple of steps, or only partially are also very welcomed!

Thanks a lot!!!

**zbor** · 10-23-2009, 05:50 AM

Earliest date without blanks is =MIN(R2:T2)

Also for Step 2 but need some more time to see how they are connected.

**DonkeyOte** · 10-23-2009, 05:51 AM

Step1

Please Login or Register  to view this content.

Step2

I don't understand the logic... based on your post - if min is

U3 -> return U1 only
V3 -> returns W1 etc... (etc means ???) .... do you in fact mean V1 ?
U3 & V3 -> return U1 & V1
V3, W3 & Y3 -> return V1, W1 & Y1

So assuming your post re: V3 is meant to return V1 rather than W1 as you state it seems you want to repeat the header where each MIN is found, correct ?

Please Login or Register  to view this content.

**OlliTbb** · 10-23-2009, 05:58 AM

Sorry, my bad! Of course it should return V1 when ealiest date is found in V. Indeed it is the headder ;-)
Thanks a lot for the answers, I'll try and reply if it worked out!

Many many thanks!!!!

**zbor** · 10-23-2009, 06:17 AM

How about this too:

=IF(MIN($U$3:$Y$3)=U3;U1;"")&IF(MIN($U$3:$Y$3)=V3;V1;"")&IF(MIN($U$3:$Y$3)=W3;W1;"")&IF(MIN($U$3:$Y$3)=X3;X1;"")&IF(MIN($U$3:$Y$3)=Y3;Y1;"")

**OlliTbb** · 10-23-2009, 07:31 AM

@ DonkeyOte:

Wow, I can´t belive my eyes... it worked!!! You are the most awesome dude ever! (Unless you are female, then I would fall in love with you ;-) )
Anyhow..., many many thanks!

@zbor:

Thanks for helping me on step I! Sorry that I didn´t try your formular regarding step II, but DonkeyOte was a bit faster. Many many thanks for your reply as well!