how could i find the nearest precedent cell with given formating

[iangel79]

hi, All,

how can i find the nearest cell that corresponds to a given formatin
(for ex: the nearest precedent cell in which there is one space befor
the text content)

thank you in advance!
I

 

[Peo Sjoblom]

This will return what's in the first cell with a leading space counted from
A1:A20


=INDEX(A1:A20,MATCH(TRUE,LEFT(A1:A20)=" ",0))

entered with ctrl + shift & enter, if you only want the row number

=MATCH(TRUE,LEFT(A1:A20)=" ",0)

entered the same way



--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)