Auto Sort in Excel 2010 - NEED HELP QUICK

[mbecker]

see post below. I want to have the column listed as per to auto sort to the largest to smallest value. This value will change throughout time.

I have data in columns a-n and rows 3-14. I want column "l" or the 12th column to auto sort from largest to smallest value.

 

[cyrilbrd]

Hi, would something like =IFERROR(LARGE($I$3:$I$14,ROWS($J$3:J3)),"") work for you?
placed in J3 and copied down to J14.
or do you want all data from all Columns to be sorted in I?

In that case with the help of a name range, you could display all data in that range sorted in a descending manner dynamically.
I am just not sure about your range as you mention Columns A to N and the results to be show within that said range in Column I...

Thanks to clarify.