Sorting a truth(or lookup) table

[feldspath]

I had the following table:

but i sorted it to color RESULT cells for duplicate values, added character formats for values near each other, etc.. . Now I want to sort it back as shown but sorting is giving me (1,1,1,1,2,2,2,3,3,....) in Parameter_3 column.

How do I sort the table back as shown?

NOTE: The table is bigger than shown since each parameter can have values 1 to 5, making 125 rows of values.

 

[NARAYANK991]

Hi ,

Use a helper column , with the formula :

=A2*100+B2*10+C2

entered in row 2 ( assuming your data starts from row 2 ) , and copied down. I have assumed your data is in columns A , B , C and D.

Now sort after including this helper column in your sort range , using the helper column for the sort order.

Narayan

 

[Jake Collins]

Or sort by parameter1 then by parameter 2 and then by parameter 3