I have a spreadsheet with info in columns A and B. I need a formula that will retrieve what is in col. A and col. B and place them both in column D with a space or 2 between the contents of column A and Column B.
Thanks
I have a spreadsheet with info in columns A and B. I need a formula that will retrieve what is in col. A and col. B and place them both in column D with a space or 2 between the contents of column A and Column B.
Thanks
This is the complete example length wise and gap wise.
The bin numbers in column A are not always in alpha numeric order. In addition there may be bin numbers inserted in the future and that is why there is gaps in numbering in colunum B. I thought that made a diference and that is why the insistance on Column B. The need for sheet 2 is to put all of the items in sheet 1 in a certain order and insert that sort order number to each item where there is a match. This item list in sheet A that is 8000 rows long must be imported into a program in a certain order. I hope this makes more sense. thanks.
I need to sort all of sheet 1 of this spreadsheet by the sort order (column B) of sheet 2 over the common field Bin Number in both. If sheet 1 does not have a match for a particular Bin Number is sheet 2 than the the row should be left blank with just the bin number listed.
thanks
O.K. everyone. I have been having trouble with this one. On the attached sheet I need to sort all of the contents of sheet 1 by the order (column B) of sheet 2 over the common field (Bin Number) in both sheets. Thanks
Thanks
I'm still having problems Mr. Weasel. I am copying the formula exaxtly but I am starting it in cell C2. The B column has the sort order number and is not empty in the brettnm spreadsheet you posted. I then coppied the formulas accross and down but got no match. I also don't want to sort by column A, I want to sort by the Column labeled sort order, (B). Can I email you the sheet I am trying to do? it is about 2.5 megs.
thanks
brett
I'm not sure what you mean by this. And i can't figure out why I'm only picking up 5 matches?
thanks
Mr. Weasel,
I'm using your formulas on the whole sheet and I am only picking up our original 5 samples. It is not picking up all the other items. What am I doing wrong?
please help
thanks
I want the final output to be a list that looks like sheet 1 but is sorted by sheet 2. if there is no match then the row should be empty accept for the bin number.
Please Help
Thanks
Thomach
The item sample is in sheet 1
This has a field called bin #
Sheet 2 also has bin numbers and a sort order for each particular bin number. How do I merge these sheets so that the sort order on sheet 2 is maintained and sheet 1 is sorted according to sheet 2?
thanks
the actual item list is 8000 rows.
If the contents of a cell contain text and some of that text comes aftera #sign (#1981F), what formula do I need to peel off the that chunk, including the number sign and dump it into the cell next door?
thanks
Thomach,
when I have a coulumn with text and some of the text is in parenthasees ( ).
How can I split off just what is in paran. and insert in column next door.
thanks
brett
Thomach, That worked nicely for me.
Once again, "you're the man"
Hey Thomach,
This idiot over here (me) is still having trouble. here is the attched sheet. You will see that in sheet 3 I'm still getting errors in Coulmn A. Thanks
Thmach,
I'm entering the following into a sheet 3 of 2 other sheets. What doesn't look right.
=vlookup(b2,Sheet1,!$A$1:$C1606,3,false)
It's telling me my formula contains an error.
thanks
Thomach,
It may not look like it, but bin numbers from shhet 2 are on sheet 1 somewhere. There are about 4000 bin numbers in the whole of sheet 1. There are about 7000 items on sheet 2. For the 4000 that match, I want the items in sheet 2 to be sorted by the order that sheet 1 is. Where there is no bin numbers for the other 3000 or so items, they can go to the bottom. Where there is a bin number on sheet 1 but no corresponding on sheet 2 those rows can be blank accept fore the bin numbers. So I know we need to find the corresponding item for that bin. I hope that makes it a bit clearer.
Thanks so much. Thomach
Thomach,
Here's another one for you. The attached apreadsheet has 2 sheets. Sheet 1 has only 2 columns but the order of the sheet is very important. It is a sort order. Sheet 2 has multiple columns and more records than sheet 1. The 2 sheets need to be merged so that the resulting spreadsheet has all of sheet 2's info but sorted over column A by sheet 1. Meaning it keeps sheet 1's order.
thanks
brett
Thanks once again thomach. You're the best.
Brett
Thomach,
That helped with one sheet and now this attached sheet won't produce the same result with the same formulas.
Thanks
Thomach, I got one more for you. The attached sheet in the "C" column describes a product and at the end has a "Bin Number" I need that 6 digit code plus hyphen bin location to be detached and appear in its own column similar to the way we you split off data in the last spreadsheet that you helped with.
Thanks
brett