Sorting Data in Tables

[Guest]

I have a fairly significant amount of data that I would like to have at least
two different methods of sorting similar to, or including a VLookup function.


For example, if comparing a widget company to the widget industry as a
whole, I would like to compare the subject company to companies with the same
gross annual sales, and of those companies to which the subject is compared,
I want the option of swithing the comparison so that the subject company is
compared to the upper quartile, or the mid-range, or the lower quartile in
net profits.

I have a Vlookup set up for the quartiles, but I also need these cells to
sort the data based on the size or type of company I am analyzing as well.
The source table has the quartile data set up horizontally and the other
variables vertically (at the moment).

 

[war_no]

Maybe my case is similar. I have data, like this (for sample) :

Name Point
A 10
B 2
C 8
D 6

I want to sort above table using formula, the result i hope is like
this:

Name Point
A 10
C 8
D 6
B 2

May i get solutions? , thanks

suwarno