Sorting Largest To Smallest

all4excel · 12-23-2007, 12:35 PM

I already have a file showing the way to do the above however I want a different approach...

I have used the Array formula which helps me in Sorting Data but though it works it unfirtunately makes the computer go slow....

Can anyone please suggest a different approach...

Please go through the file....

Thanking you in anticipation.

**oldchippy** · 12-23-2007, 02:57 PM

Instead of using A:B in your lookup, lookup the actual range i.e. A1:B500. Does that make any difference?

all4excel · 12-24-2007, 02:13 PM

Originally Posted by oldchippy

Instead of using A:B in your lookup, lookup the actual range i.e. A1:B500. Does that make any difference?

Dear oldchippy, i did try what u asked of me, however i wanted a different approach to save memory as I have more than 10 sheets with Array formulas which is reducing my speed.

all4excel · 12-24-2007, 02:27 PM

Originally Posted by oldchippy

Instead of using A:B in your lookup, lookup the actual range i.e. A1:B500. Does that make any difference?

Want a different approach over an Array formula

Dear chippy, I tried ur approach but i want a different logic/approach instead of using the Array formula { } to sort he largest / smallest value in the file.

**vane0326** · 12-24-2007, 10:30 PM

Originally Posted by all4excel

Want a different approach over an Array formula

Dear chippy, I tried ur approach but i want a different logic/approach instead of using the Array formula { } to sort he largest / smallest value in the file.

A helper column always seems best.

Select column A and insert a new column.

Input cell A2 and copy down.

=C2*10000+ROWS($A$2:$A2)

Input formula in cell F2 and copy down.

=INDEX($B$2:$B$10000,MATCH(LARGE($A$2:$A$10000,ROWS($F$2:$F2)),$A$2:$A$10000,0),1)

Hope it helps!

all4excel · 12-25-2007, 02:07 AM

Originally Posted by vane0326

A helper column always seems best.

Select column A and insert a new column.

Input cell A2 and copy down.

=C2*10000+ROWS($A$2:$A2)

Input formula in cell F2 and copy down.

=INDEX($B$2:$B$10000,MATCH(LARGE($A$2:$A$10000,ROWS($F$2:$F2)),$A$2:$A$10000,0),1)

Hope it helps!

Thnks a lot vane It worked really well...