Excel Function
 

In a worksheet for e.g. Row No. A1 to A6, I have Entered some data
in-between specified range (i.e. A1 to A6) A2, A4, A6, I want to pick up the
data entered in that specified range in B1 to B6 in a SEQUENCE

Example :

ROW NO. INPUT ROW NO OUTPUT
A1 B1 15
A2 15 B2 6
A3 B3 35
A4 6 B4
A5 B5
A6 35 B6


Please guide me which function will solve the problem and I would like to
inform you that it should skip the blank cell, The output should pickup the
only filled data in sequence order as inputed in row A1 to A6.

Hi,
In B1,put formula as
=if(a1<"",a1,if(a2<"",a2,if(a3<"",a3,if(a4<"", a4,if(a5<"",a5,if(a6<"",a6,"")))))).
Repeat this in B2,starting from a2; in B3,starting from a3; and so on ...
If the number of rows is more than 7,this formula may not give the desired
result.
K.S.Warrier

"Chandrashekhar" wrote:

In a worksheet for e.g. Row No. A1 to A6, I have Entered some data
in-between specified range (i.e. A1 to A6) A2, A4, A6, I want to pick up the
data entered in that specified range in B1 to B6 in a SEQUENCE

Example :

ROW NO. INPUT ROW NO OUTPUT
A1 B1 15
A2 15 B2 6
A3 B3 35
A4 6 B4
A5 B5
A6 35 B6


Please guide me which function will solve the problem and I would like to
inform you that it should skip the blank cell, The output should pickup the
only filled data in sequence order as inputed in row A1 to A6.