I have a data in excel in the format: Description Name Percent Always A 52 Sometimes A 23 Usually A 25 Always B 60 Sometimes B 30 Usually B 15 Always C 75 Sometimes C 11 Usually C 14 I want to sort this data: For each name the sequence of description has to be same (eg: always followed by sometimes followed by usually) but for three names A, B and C, I want to sort the always percent from smallest to largest. Eg: I want the above example to look like this after sorting: Description Name Percent Always C 75 Sometimes C 11 Usually C 14 Always B 60 Sometimes B 30 Usually B 15 Always A 52 Sometimes A 23 Usually A 25 The always percent of name C was highest and always percent of name A was lowest. I hope I was able to explain it. I would really appreciate your help regarding the same. I can't see a one-step approach, but try the following. (It's actually not as complicated as it looks: it's just hard to explain both succinctly and clearly!) It is based on the assumption that the rows in the initial data are always in the desired relative order, i.e. • Always • Sometimes • Usually If this is true (rather than a coincidence in your example data), then you can create a 4th column, for the purposes of sorting, that generates numbers that can be sorted in your desired order.

Summary of approach • Create a new column, containing data derived from your Percent values, that will retain the desired order of each set of 3 rows during sorting • Convert the cells in this new column from formulae to values, so the values are not changed during the sort • Sort the data on this new column (descending), with Name as the second sort key. Detailed steps In case the above is not enough info: • Create a 4th column: let's call it Ordering • D1: Ordering • Give the first three rows in Ordering the following formulae: • D2: =C2+2 (i.e. 54 in your example) • D3: =C2+1 (i.e. 53) • D4: =C2 (i.e. 52) • Select those 3 cells, and Fill Down to the bottom of your data, so for example, the next 3 rows would contain: • D5: =C5+2 (i.e. 62 in your example) • D6: =C5+1 (i.e. 61) • D7: =C5 (i.e.

Here are the steps to convert the entire column to date format values. Add a column to the right of the date column. Right click the new column and select Format. Set the format to date. Highlight the entire old date column and copy it. Highlight the top cell of the new column and select Paste Special, and only paste values. Luckily, Word gives you much of the same flexibility to sort text as found in Excel. Suppose you have a table in Word that looks like the one below. Notice that there are column headings in the first row and that the first column contains the text we wish to sort.

60) Note 1: I'm really impressed/amazed that Excel's 'Fill Down' mechanism populates the formulae as you need it here, at least on Excel 2010 on Windows. Do check the resultant values yourself, to ensure the Mac one behaves the same. Note 2: Don't be temped to do the Sort at this point, as the relative references get broken during the sort, and you end with an #REF! In D2 • Copy the Ordering column to the clipboard • Paste the Ordering column as Values, i.e. To replace the above formulae by the values that they calculated • Now do your Custom sort • On Ordering, Descending • On Name, Ascending With your original data, this gives the desired result. The Sort on Name is for the case where 2 sets of 3 rows have the same Percent value. Otherwise the results for the two different Names could get mixed up (if Excel's sort doesn't retain the initial relative order).

• The design is very fresh. Pros • The interface customization is ideal.