macro to get data in alternate manner.

[kshitij_dch]

Hi all ,

i am on a excel sheet where in i have 2 names "LIP" and "GIP" in column A. data is like

GIP
GIP
LIP
LIP
LIP
LIP
GIP
LIP
GIP
GIP
GIP
GIP
GIP
LIP
LIP

I need the rows should be arranged in alternate manner. like

GIP
LIP
GIP
LIP
GIP
LIP and so on........

Any macro or formula to do that ?

 

[footoo]

Here's a way to do it manually :

• Sort by column A
• In an empty column, fill sequential numbers starting with 1 in the GIP first row down to the last GIP row. Do the same for the LIP rows.
• Sort by the sequential numbers column.

 

[kshitij_dch]

No able to do it if can help me with a macro or a formula ?

 

[footoo]

No able to do it

Not able to do what?

(I note that your name falls within the board's censorship rules. )