I have two fields on an Excel spreadsheet. One field is a member_id number, the other field is a generated sequence number which has the number of records for that ID. I am trying to sort by descending sequence of sequence number within ascending sequence of member_id. I am using custom sort, but I cannot seem to get the sequence number to sort in descending sequence. The sequence number is created by a formula, whic adds 1 if the member_id is the same and sets to e1 one different.
How can I sort this file?