what if formula


B

bob245

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
 
Ad

Advertisements

J

Joe User

bob245 said:
Thanks for your recent post for my excel problem. [....]
I still cant get it to work

Sure would be nice to know what it is that you cannot get to work. If you
had posted your follow-up to the same thread, we would have that context, and
we could help you.

Maybe you'll get lucky and someone will make the effort to connect the dots.
I wish they wouldn't. Newbies need to be taught to use common sense.


----- original message -----
 
J

JLatham

The other discussion is here
http://www.microsoft.com/office/com...a8b1&cid=2cf1080c-f3db-4fcc-b135-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)
 
B

bob245

--
Thanks Bob


JLatham said:
The other discussion is here:
http://www.microsoft.com/office/com...a8b1&cid=2cf1080c-f3db-4fcc-b135-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)

Sorry if I didn’t make my self clear at first.

What I’m trying to do is,
I have an estimate spread sheet with several columns,
In row (A1) I have the word bid, and in (A2) there is a work description.
Row (B1and B2) (C1 and C2) are left blank.
Row (D1 has the word Bid and D2 has a company name)
Row (E1 is the bid cost and E2 is the company address)
The next several rows are duplicates of D and E rows
Different costs, names and address.

What I hope is possible is to use a formula that will take
The low bid in column A and the Company name in column B and Address in
column B
And automatically move this information to rows B and C with the lowest
bidder in this row
I would like to keep this format because I have 4 more columns to the right
of what I described, labor,materials, percent markup and totals
 
Ad

Advertisements

J

JLatham

I think Don Guillett had a handle on it, but I'm having some trouble seeing
it all.

What you need is a MIN() formula that picks up the minimum bid amount from a
column. That would pull the minimum bid to whatever cell you put that
formula into.
Then you need a MATCH() formula to match that low bid in the list of bids
(would give you a row number) and that would be a part of a formula that
would then pick up the company name and address.

I think if I could see a workbook with actual/sample data in it, and a clear
writeup of what you need again, and (as Don so often asks for) a before and
after example, I could help with this. If you want to give that a try, get
in touch and attach a sample workbook via email to (remove spaces)
Help From @ JLatham Site. com
No promises, but I'll give it a shot.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top