Forum Discussion
Joe_Blough
Mar 19, 2024Copper Contributor
Sort Excel rows in numerical order
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
- Detlef_LewinSilver Contributor
- Joe_BloughCopper Contributor
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 ?- Detlef_LewinSilver Contributor
It looks like your cells are empty. Check the cells and the ranges in the formula.