Forum Discussion
excel
Dear Excel community
i have a issue with excel , i have a chart with data and i sorted the last names but i have 2 people with same last name. the first person is named kevin and the second dennis but kevin comes before dennis on the chart and i would like that dennis comes before kevin because dennis comes before kevin in the alphabet. i have i screenschot of the chart down below. help would be verry apreciated.
1 Reply
Click anywhere in the data.
On the Home tab of the ribbon, select Sort & Filter > Custom Filter..., or click Filter on the Data tab of the ribbon.
Select Naam from the 'Sort by' drop-down.
Click '+Add Level'.
Select Voornaam from the second 'Sort by' drop-down.
Click OK.
