CODEWITHSUNDEEP
excelvbaexcel-formula
panji gemilang
panji gemilang

Reputation: 809

Sorting excel formula value (Dynamic) with same value

I have data that has much same value. So I want to sort it by the value but also by alphabetical. This is the data :

the data

the value of 'information gain' was a formula. How can I sort it by value and also by alphabetical ascending (A - Z)?

Upvotes: 1

Views: 169

Answers (1)

Regiz
Regiz

Reputation: 467

Hope it's easy by following below steps.

Refer below as an example.

The B column as name is not in order as A-Z and The C column values in formulas.

Select the Data => Then use The Short cut of Alt + A + S + S to sort the table. In first condition select the information Gain and the order by can be Smallest to largest or largest to smallest as per your requirement, and then B Column of Kata in second condition which order should be A-Z

enter image description here

Here is the final result after using the above mentioned short cut option:

enter image description here

Please let me know if it doesn't worked. So that will find for a new solution.

Upvotes: 3

Related Questions