Sort Excel rows in numerical order

Copper Contributor

Picture2.png

I working a spread sheet with over 3k of rows that need to be sorted in numerical order for cells C2:G2 for each row, in all 3k of rows while keeping the other data in the row intact.

 

I tried the sort custom and sort left to right but that would be time consuming for 3K rows

 

I'm trying to accomplish this the easiest way as i am a beginner.

If you provide the steps to implement I can initiate the steps required. 

 

any help would be appreciated 

 

thank you 

3 Replies

@Joe_Blough 

Try this.

=HSTACK(B2,SORT(C2:I2,,,TRUE),H2:I2)

thank you for responding

i insert the h stack in cell j2 to test the first row and received this output
TUESDAY + 0 0 0 0 0 0 0 0 0

I'm assuming I pasted it in the wrong cell location ?

@Joe_Blough 

It looks like your cells are empty. Check the cells and the ranges in the formula.