Sort Excel rows in numerical order

Copper Contributor


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


Try this.


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 ?


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