Formula Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi to all
Im looking for a formula or maybe code to use in the following situation.....I would like to return in cell B1:Z1 the date from column a that corresponds with the first nonblank cell in the column
A B
1 3/3/03 3/4/0




6 3/3/03 10
7 10
8 10

10 3/4/03 10
11 10
1

Thanks
Denise
 
Hi Denise
try the following array formula in B1 (entered with CTRL+SHIFT+ENTER):
=INDEX($A$1:$A$100,MIN(IF(B$2:B$100<>"",ROW(B$2:B$100))))
and copy to the right
 
Thanks for the reply Fran
Modified for my ranges, this is what I am usin
=INDEX($A$7:$A$1000,MIN(IF(B$7:B$1000<>"",ROW(B$7:B$1000)))) shift+ctrl+ente

The formula is still in B1 but the data resides in B7:B100

Im getting back 1/0/0 which is zero value formatted as date

Any idea
 
Back
Top