I want to create a table which collects data from a certin cells in me
worksheet, after collecting the data. i want the table to autosort it
self by some categories.

same principle as they did the mondial file:

http://38.113.149.34/MONDIAL.xls


I just don't understand what forumla in which they used that make the
table sort itself.

if anyone can give me a brief explanation,I'd really appreciate it.

Going by your subject line ..

Here's a simple rendition to illustrate one way to set it up using non-array
formulas (Full details inside the file, in English, from left to right <g):
http://www.savefile.com/files/5659668
Simple Auto-Sort Example.xls

The example you posted:
http://38.113.149.34/MONDIAL.xls
carries sophisticated criteria within hidden cols AA to CB
(just unhide the cols to see what's there)

but the underlying principle's there ..

You have an original table, say a col list of countries in a tournament and
with an adjacent points col, points manually entered (or the points could be
computed by formulas pointing to scores manually entered in the table - my
example doesn't cover this part, but it does cover the possibility of tied
points occuring). Then as the points are entered, another mirror table (to
the right of the original, say) could be set up to produce the auto-sorted
version.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Taitan-x" wrote:
I want to create a table which collects data from a certin cells in me
worksheet, after collecting the data. i want the table to autosort it
self by some categories.

same principle as they did the mondial file:

http://38.113.149.34/MONDIAL.xls


I just don't understand what forumla in which they used that make the
table sort itself.

if anyone can give me a brief explanation,I'd really appreciate it.