The other discussion is he
http://www.microsoft.com/office/comm...5-2712fa8c8a82

As Diane said, I don't think it's going to be easy the way you appear to
have it laid out. Would be an absolute "piece of cake" if you laid it out
with all information on one row, as
Bidder Name Amount Bid Address
Then it would be a simple matter of sorting by the 'Amount Bid' column. And
take less room on your sheet.

Don Guillet offered this in the other discussion, what is it that you have a
problem with? (I haven't tried any of it out myself yet)

A helper column in B
=IF(LEFT(A5,1)="$",VALUE(LEFT(A5,FIND(" ",A5)-1)),"")
for the name
=INDEX(A:A,MATCH(MIN($B$4:$B$44),$B$4:$B$44))
=INDEX(A:A,MATCH(MIN($B$4:$B$44),$B$4:$B$44)+1)

"bob245" wrote:

Thanks for your recent post for my excel problem. (Does anybody know how to
move set of cells so the lowest number plus info in
cells to the right can be to top cells.)

I still cant get it to work, attached is a sample spread sheet. your help
would be greatly appreciated.

A B
1 Selective Demolition Division 1
2
3 BID low bid name here
4 low bid here low bid address here
5 BID Joes
6 $250.00 3746 So Star Street
7 BID Tims
8 $750.00 7538 East long street
9 BID Erics
10 $50.00 9837 South 345 East
11 BID Terrys
12 $100.00 5849 East Street
13 BID Jeffs
14 $25.00 487 East Green Street

--
Thanks Bob