Excel Change String Of Text In One Column With Other Column Data?
Sep 13, 2013
I want to take what is in column A and replace the number after the "=" with new number.
I need a formula that identifies the 6 numbers or letters after the = and replaces with column A
111111 showstocknumnber//details.php?vid=111111
222222 showstocknumnber//details.php?vid=111111
345673 showstocknumnber//details.php?vid=111111
The 111111 after the = could be any string of 6 letters and numbers. The contents of column b are a URL.
View 1 Replies
ADVERTISEMENT
Mar 5, 2014
I am trying to count the distinct times a value shows up in a column, if another column has a 2 in it.
For example:
Columns
A, B
2,P25
2,P25
3,P5
3,P6
2,P5
The results shoud be: (2) Because I only want to count the P25 one time.
I'm using Excel 2010
View 2 Replies
View Related
May 30, 2014
I am trying to find a way to populate a column based on the changes in the data of another column...
For example, I want to fill in the code column....so when the customers cost changes, I want a numeric code to populate & change. So for the first 5 lines, the code could be 21, and then when the cost changes to $37.51, want the code to change to 22.
CodeCustomer's Cost
$34.10
$34.10
$34.10
$34.10
$34.10
$37.51
$37.51
$32.50
$32.50
$33.48
$33.48
$34.10
$37.51
$37.51
View 7 Replies
View Related
Feb 19, 2014
I have a situation that I cannot get my hands on. I have a set of Project Numbers in my Column A. (Will Try to post an example).
I need that everytime I change a number in my Column B that it will change all the numbers, in my column B, based on the matching Text in my Column A.
Demo1.xlsm
View 14 Replies
View Related
Aug 29, 2007
How do I search a given text "GNMA" from a cell (A1) and (A2) and return it in other cell (B1) and (B2).
Example:
A
1 GNMA-4565X18-ROE
2 895GNMA-12
View 9 Replies
View Related
Feb 7, 2014
I am in need of restructuring a spreadsheet of addresses for mailing purposes. (I tried to find something similar answered previously, but nothing seemed to work for me.)
I have attached a small example spreadsheet below, but our spreadsheets can be hundreds or thousands of rows in length.
I need a macro that will look for the "PO Box" addresses under the column headers named "ADDRESS2" and "ADDRESS3".
The PO Box addresses will need to be moved under the column header "ADDRESS1" within the same row.
It will need to overwrite the text that is already under "ADDRESS1" and delete the text from the "ADDRESS2" and "ADDRESS3" columns - UNLESS the text in 'ADDRESS2" is a PO Box AND "ADDRESS1" begins with "c/o".
If the data in "ADDRESS2" or "ADDRESS3" is anything other than a PO Box it will remain the same. As will "ADDRESS 1".
Basically if there is a PO Box it needs to be in the column named "ADDRESS1" and overwrite anything else that was there. The exception will be for PO Boxes that are in c/o someone else, the PO Box will then need to be listed in the column directly after the column that has c/o.
If the c/o exception will be too difficult the code could just highlight those scenarios and we could fix them manually. We usually do not have a lot of them, but enough that we need to be mindful of them.
The different scenarios are listed in my sample spreadsheet.Also, the code will have to use the column header names in row 1 because those headers are not always in the same column.
View 14 Replies
View Related
May 26, 2009
i want to extract a value from a column into another column in excel.
this first column contains text and i want to extract a value that in located between the characters 'FOR' and 'MTHS'.
how do i do that?
the situation is the same for all the rows; the value that i want is just located between these characters.
is there a simpler way other than using the MID functn? because everytime i use it i need to count the no. of characters and its quite difficult to keep up with the numbers.
View 2 Replies
View Related
Sep 23, 2013
I have one column that has forename and surname information and I need to separate the surname into a separate column next to the forename.
Is there a formula for this?
I've tried the formula where you can request to move so many characters to the right, but it's difficult with all of the surnames being a different number of characters.
View 2 Replies
View Related
Sep 24, 2013
I have trying to find the maximum date value in a series of campaigns with the same name [Combnined Campaign (Campaign)] , the aim is to pick the lowest version of the same name if the campaign is connected and pull the max end dates and number of weeks [Week Number Combined Campaign] that overall campaign has been running. A spreadsheet below explains this too.
What I need is to search for all the campaign names in column [Combined Campaign (Campaign)] and find the matching week number. What I am currently using is this formula:
=IFERROR(IF(E2="Yes",INDEX($A$1:$K$26,MAX(MATCH(F2,$G$1:$G$26,0),1),COLUMN($K$1:$K$26)),""),"")
Yet Max doesn't work with text.
Campaign Appeal Code
Launch Month
Market
Product
Combined Campaign (Yes/No)
Combined Campaign (Campaign)
Channel
Start Date
End Date
Week Number
Week Number If Combined Campaign
AAB13
Jan
Yes
AAB13
Mail
01/01/13
31/01/13
Complete
[Code] .........
View 2 Replies
View Related
May 3, 2013
I am looking for a macros VBA where a user insert or update a data the date and time should be insert in column I and save the workbook.
Note: If the column I already have the date and time inserted before then it should give message record already have date and time.
I am using office 2010.
View 9 Replies
View Related
Aug 15, 2013
So, using an array under the Names column, search the string under combined names and break apart as illustrated. Must stay on the same line...w/o VBA.
Combined Name(A)
Names(B)
LeftofName(C)
[Code].....
View 1 Replies
View Related
Jul 13, 2011
I am trying to use ADO via VB6 to find a specific input in row A of my excel sheet.
I then want it to return the Column and Row to me separately.
I have a code I already use for returning specific values from cells:
Code:
Function Look(ClosedWorkbookFullName As String, _
SheetName As String, RangeAddress As String) As Variant
Dim conn As Object, rs As Object, SQL As String
Set conn = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")
[Code] ......
Now I want something like this I can use as a function, but it obviously needs tweaks.
View 1 Replies
View Related
Feb 21, 2007
I have a data something like this:......................
The script should notice a word "color" in the cell of the row B, copy it to row A and fill down until the next cell filled fith word "color". Important: It can be some other words afte word "color" comething like color 1, color 234q etc. But "color" always the first word in the cell
View 5 Replies
View Related
Jul 9, 2014
Why my code is not working. I am working with Excel 2010. It will only delete the column on the active spreadsheet and not go to next worksheet. Not all worksheets contain the word "Broker".
[Code] ......
Not sure if its something to do with Activecell, try After:=ws.cells(1,1) or passing it in as the active cell stays the same i think.
View 3 Replies
View Related
Jan 14, 2009
Can I use a macro to change text in a cell? As an example, I have this list of names in a column. I'd like every other name to have a semicolon instead of a comma after the name. My list has commas now
Tommy,
Joe,
Warren.
Billy,
Bob,
George,
And I want it to look like this.
Tommy,
Joe;
Warren.
Billy;
Bob,
George;
Since I'm using macros on this page, I'd like to use a macro to do this
View 3 Replies
View Related
Oct 5, 2009
I am trying to write a macro to search a column for a specific text string which when found, will copy the whole row the string is in. Once this row has been copied, I then want the macro to activate a new sheet and search for the next available empty row to paste the data. Once this has been done, go back to the original sheet and find the next cell in the original column with the specified text string and repeat until the range has been satisfied. Below is the script I have that sort of works.
View 5 Replies
View Related
Feb 7, 2014
I have a code i want to fill down a column, but have the row change to the corresponding row it's on
So for example, the code is '= code128(A7)' on row 7. How to fill it down, but they ALL say (A7) on row 8, i need to change it to '(A8)' and next '(A9)' and so on.
View 1 Replies
View Related
Feb 28, 2014
I have a spreadsheet of several thousand named items (in column B) with values associated with them in column A). The "name" field is a string of several alternative names for the item.
I have a list of ~50 items that I am trying to find the values for. Each uses one of the alternate names.
What I want is a function that will return the associated value in column A when one of my shortlist names is found.
For example, my big spreadsheet looks like:
AB
1dallas, DFW. 12345
2Atlanta, ATL, 23456
3Boston, BOS, 34567
4Chicago, CHI, 45678
5Los Angles, LA, LAX, 56789
And my list looks like
Atlanta
CHI
I want the output to look something like:
Atlanta2
CHI 4
Is the feasible? IT seems like there should be a way to do it....
View 2 Replies
View Related
Jun 8, 2006
I am having trouble figuring out how to split the data in a column.
For Example on the attached .xls - the first few records under the SIC column are:
73790200
59470104
70110100
581223
& how i want them to look in seperate columns:
73 790200
59 470104
70 110100
58 1223
I need the first two digits in their own column and the rest of the number in it's own column. I have over 6,000 records, so doing it manually is not a place I want to go!
View 3 Replies
View Related
Apr 1, 2014
I have a list of pricing and I want to be able to change the text of cell, say "D1", which says "Standard" to say "Premium" and all the formulas would change in accordance. The "Standard" pricing would be, Starting D2, "=C2*.3" and I want them all to go to "Premium" pricing which would be formula "=C2*.35".
What would be the best method of creating this function or formula?
View 3 Replies
View Related
Jan 17, 2013
macro for an Excel 2007 file. It has to be a macro. I have cells in two columns I need to look at. Column A will have a value of cat, dog, or mouse. Column B will have a date. If A2="mouse" AND B2<"1/1/2013" Then A2="" ElseIf A2=mouse" AND B2>="1/1/2013" Then A2="mouse". I don't need anything to happen if A2 is equal to cat or dog. The macro has to move down the entire A and B column: A3/B3, A4/B4, and so on until the end of the columns. Hope this makes sense. I've tried a few macro samples I found online but they don't quite fit what I need done, or I don't know how to modify it.
View 2 Replies
View Related
Mar 22, 2007
I have a simple lists containing two columns. One column contains a five digit number and the other a vendor name. The vendor name in most cases is two to four words. I am wanting to type in a partial string of the vendor name and it return to me the 5 digit 'vendor' number.
Col A Col B
20567 3M Electrical, Inc.
I want to type in '3m' or '3M' or 'electrical' or 'ELECTRI' and it return the 20567. The other part of this is that there may be two rows with the same info in which I would need to see both...
Col A Col B
20567 3M Electrical, Inc.
21789 3M Tape Division
Is this possible with standard lookup features in Excel or does someone have a VbScript or macro that will accomplish this?
View 9 Replies
View Related
Jan 31, 2013
I have a large spreadsheet converted from pdf whose data still appears in A4 reading format.
I need to move part columns of data from 6 columns to form 1 large column in column A.
For example, move range B8 to B76 beneath range A8 to A76 and range C8 to C76 beneath that etc, page by page working through all 270 pages !
Also need to delete unnecessary 'page headers' throughout as in rows 2-6
View 2 Replies
View Related
Mar 27, 2014
I am using Excel 2010. I need to copy a list from any Column on the right to the existing Column. See the sample file.
View 10 Replies
View Related
Mar 17, 2012
I am trying to add columns to my Excel 2010 Pivot Table to calculate % change of sales from year to year. The field name is "Year", while the item columns in the field are 2007, 2008, 2009, 2010, and 2011. How do I add a column between the years that will calculate the % change os sales up or down from the previous year?
View 2 Replies
View Related
Apr 15, 2014
I'm working on a decision matrix to evaluate different alternative production methods. Before that criteria have to be choosen and weighted against each other. The user would fill out the yellow/ blue cells with (0=less important; 1=equally; 2=more). Then values are added up and put into some kind of ranking.
The example was done by hand, which costs a lot of concentration. I would now like to extend the matrix - do you know how to fill out the grey cells more efficiently?
(Excel 2007, Win7)
View 1 Replies
View Related
Jun 30, 2014
I have a excelsheet that looks like this:
Column A | Column B | Column C
Los Angeles | Fire Dept | 3
Los Angeles | Health Services | 12
New York | Fire Dept | 8
New York | Health Services | 22
New York | Internal Services | 100
New York | Public Works | 7
Chicago | Health Services | 15
Chicago | Public Works | 56
Chicago | Social Services | 4
And I am trying to make it look like this:
Fire Dept
Health Services
Internal Services
Public Works
Social Services
Los Angeles
3
12
New York
8
22
100
7
Chicago
15
56
4
View 8 Replies
View Related
Oct 27, 2013
I am trying to bulk upload some geo locations for my site, but the data I have is longtude first and latitude after, whereas the site accepts the data reverse, which means latitude, longitude.
that it's possible to change the order somehow.
Here is a example of how it looks:
"(12.595342677449292 55.66937339270993, 12.595097670457731 55.669239938648126)"
View 13 Replies
View Related
Jul 27, 2009
I have a spreadsheet with a column of data that is similar for a while, then changes, is similar, then changes. I need to number them as each set of data changes, how can I go about that?
Here is an example of what I have:
Dog
Dog
Dog
Cat
Cat
Bird
Bird
Bird
Bird
Lion
Elephant
Elephant.....................
View 5 Replies
View Related
Jun 24, 2009
I have this macro below and would like the code changed to find the "Customer Number" column by name rather than by column B. Note that the "Customer Number" column will always be somewhere in row 1.
View 12 Replies
View Related
