Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
what if formula
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
what if formula
"bob245" wrote:
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 ----- "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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
what if formula
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
what if formula
-- Thanks Bob "JLatham" wrote: 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 Sorry if I didnt make my self clear at first. What Im 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
what if formula
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. "bob245" wrote: -- Thanks Bob "JLatham" wrote: 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 Sorry if I didnt make my self clear at first. What Im 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|