sort data = COUNTA
(Click image to enlarge)
This is the case of a form where need to sort the list by COURT (column C) and then SECRETARIAT (column D), but in turn need to have the CAUSES (column E), in alphabetical order in each trial.
To sort data in Excel always have to select (paint) all the data.
A mistake at this stage can yield disastrous results. Paint
then RETURN ALL, including the column headings.
Now, right click and choose Sort and then custom order.
1) Sort by COURT
2) Then by SECR
3) Then by CAUSE
and so is
0 comments:
Post a Comment