M
Maria
Bernard Liengme said:Your message is a little less than clear
Are you actually using a Pivot Table?
Why do you think Data | Sort does not work in XL2000?
What do your mean by "total value of the word string" ?
Maybe an example of 5-10 rows of data would help
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
Yes, sorry I am not explaining this very well...
I have something like this:
Search String Value
Hello $114.95
help $17.90
thank you $27.90
thank you $87.90
thank you $87.90
I have made this into a pivot tabel by putting the search strings in ROW and
search string as well as value in DATA. This lookes somehing like:
Search String Data Total
Hello Count of Search String 1
Sum of Order Value 114.95
Help Count of Search String 1
Sum of Order Value 17.90
Thank you Count of Search String 3
Sum of Order Value 203.70
I want to sort this pivot table after the search string that is the most
common and therefore has the highest count of search string. And if there are
search strings that are equally as common then they should sort after value.
If I use Data~sort it will not sort after two different things.
Thanks!