LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
REI PRO
 
Posts: n/a
Default PLEASE HELP - Data Sort


I have a worksheet that calculates numbers. There are multiple lines and
each has a different result.

Is there a way to have the data automatically sorted so the highest or
lowest value comes to the top?

Example: Before Data Sort
Bank Financing $60,180.00
Capital Investments $24,902.0
Cash $213,780.00
65% LTV Program 2 $28,987.50

Example: After Data Sort
Cash $213,780.00
Bank Financing $60,180.00
65% LTV Program 2 $28,987.50
Capital Investments $24,902.00

Any help that can be provided would be greatly appreciated.

Thanks in advance.

Respectfully,

Phil



--
REI PRO
------------------------------------------------------------------------
REI PRO's Profile:
http://www.excelforum.com/member.php...o&userid=31703
View this thread: http://www.excelforum.com/showthread...hreadid=514058

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort order : Excel vs imported data John Excel Discussion (Misc queries) 0 December 9th 05 01:40 PM
sort data on multiple worksheets bill Excel Discussion (Misc queries) 0 November 29th 05 05:52 PM
macro to sort data in worksheet by specific date joey Excel Discussion (Misc queries) 0 November 14th 05 07:59 PM
Why won't my newly entered data sort with old data ? laura Excel Discussion (Misc queries) 2 August 3rd 05 04:26 PM
sort column data with hidden columns - excel 2003 nanimadrina Excel Discussion (Misc queries) 2 April 26th 05 08:27 PM


All times are GMT +1. The time now is 02:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"