Sorting All rows based on a column values which should remain as it is.

[svelma]

Hi,

I have multiple columns and rows, of which two columns(Say column G & column H) have similar data(text) but in different order. The second column H has the right order and should remain as it is.

Now, I want to sort rows for all columns from A to G(but not H), such that the resulting values in G and H are in same order.

*Note: The number of rows till column G are 265 and number of rows in column H are only 42.

I am kind of new to excel and have little knowledge, so can somebody please help me out.

Thanks,
Velma.

 

[Jonmo1]

Welcome to the board.

Just make sure you are selecting only Columns A Through G when you go to sort.
When it asks you if you want to "Expand your selection" - Say No.

Hope that helps.

 

[andiemac]

Add a column between G and H. Now your H data is in I,
In the new, blank columjn of H enter =match(G2,I:I,0) adn fill down
then sort by H.

If you want to set this up as a macro you can record yourself adding the column, selecting I2 and then filing down. You will want to add in
Range("I2").value = "=match(G2,I:I,0)" before the fill down action.

**sorry, usually a better typer, but my finger is in a splint**

 

[svelma]

Thank for the reply guys. Andiemac, =match(G2,I:I,0) and sorting by column H worked like a charm. Thank you. You saved me a lot of time.