Formula wanted

Hi.
I have two columns in Excel. In first column A1:A100 i have some integers
and empty cells and in second B1:B100 I have some stings and also some
empty
cells. I would like to apply a formula in C1:C100 somehow in a way:

a) to include all stings Bi that the corresponding Ai are numbers
b) with non blank cells in C1:C100 (That means all the strings in C column
will be in successive order. For example C1«C, C2=GEORGE, C3ÌD e.g.)

Any idea?

Thank you.

Try this array formula

=IF(ISERROR(SMALL(IF($A$1:$A$20<>"",ROW($A$1:$A$20)),ROW(A1))),"",
INDEX(B:B,SMALL(IF($A$1:$A$20<>"",ROW($A$1:$A$20)),ROW(A1))))


HTH

Bob

"George" wrote in message
news:
> Hi.
> I have two columns in Excel. In first column A1:A100 i have some integers
> and empty cells and in second B1:B100 I have some stings and also some
> empty
> cells. I would like to apply a formula in C1:C100 somehow in a way:
>
> a) to include all stings Bi that the corresponding Ai are numbers
> b) with non blank cells in C1:C100 (That means all the strings in C column
> will be in successive order. For example C1«C, C2=GEORGE, C3ÌD e.g.)
>
> Any idea?
>
> Thank you.
>


.

Thank you but didn't work. But I get some ideas from this and I am close
to
a solution.

"Bob Phillips" wrote:

Try this array formula

=IF(ISERROR(SMALL(IF($A$1:$A$20<>"",ROW($A$1:$A$20)),ROW(A1))),"",
INDEX(B:B,SMALL(IF($A$1:$A$20<>"",ROW($A$1:$A$20)),ROW(A1))))


HTH

Bob

"George" wrote in message
news:
> Hi.
> I have two columns in Excel. In first column A1:A100 i have some
> integers
> and empty cells and in second B1:B100 I have some stings and also some
> empty
> cells. I would like to apply a formula in C1:C100 somehow in a way:
>
> a) to include all stings Bi that the corresponding Ai are numbers
> b) with non blank cells in C1:C100 (That means all the strings in C
> column
> will be in successive order. For example C1«C, C2=GEORGE, C3ÌD
> e.g.)
>
> Any idea?
>
> Thank you.
>


.

Did you array enter it?

It worked in my tests, so in what way did it not work?


HTH

Bob

"George" wrote in message
news:
> Thank you but didn't work. But I get some ideas from this and I am close
> to
> a solution.
>
> "Bob Phillips" wrote:
>
>> Try this array formula
>>
>> =IF(ISERROR(SMALL(IF($A$1:$A$20<>"",ROW($A$1:$A$20)),ROW(A1))),"",
>> INDEX(B:B,SMALL(IF($A$1:$A$20<>"",ROW($A$1:$A$20)),ROW(A1))))
>>
>>
>> HTH
>>
>> Bob
>>
>> "George" wrote in message
>> news:
>> > Hi.
>> > I have two columns in Excel. In first column A1:A100 i have some
>> > integers
>> > and empty cells and in second B1:B100 I have some stings and also some
>> > empty
>> > cells. I would like to apply a formula in C1:C100 somehow in a way:
>> >
>> > a) to include all stings Bi that the corresponding Ai are numbers
>> > b) with non blank cells in C1:C100 (That means all the strings in C
>> > column
>> > will be in successive order. For example C1«C, C2=GEORGE, C3ÌD
>> > e.g.)
>> >
>> > Any idea?
>> >
>> > Thank you.
>> >
>>
>>
>> .
>>


.