Unique Keyword List
Feb 19, 2007
I have a large keyword list
lets say it's 25,676 keyword phrases all in ColA (Always from A3 downwards).
I delete rows as I'm sorting so the number does very.
The sheet tab is always called "All KWs" (For All Keywords Not surprisingly)
What I would like is a macro that does the following.
Can it look at all the keyword phrases on sheet "All KWs" in ColA (From A3 downwards and make a list on a new sheet of just unique keywords from the list.
This sheet will be called "Unique keywords"
So, can it return on this sheet called "Unique keywords" all the unique keywords from the large list in ColA (From A3 downwards) on the sheet "All KWs".
If it can return only unique words and numbers etc, removing all duplicates.
If it can do this From A3 downwards.....
View 9 Replies
ADVERTISEMENT
Dec 24, 2006
What I'm trying to achieve is the following;
I have a big keyword list saved in Excel.
Something like the following,
These are all keyword phrases;
car rent
car hire
cars for rent uk
etc etc etc
All listed in Column A
All phrases in Column A, and in separate rows.(1 phrase per row.)about 2000 lines (Rows) in total.
What I want to know is there any way of selecting the whole list and exporting it (To save it as another list. A list of just unique keywords?
So, It would create a list like;
car
rent
uk
hire
for
etc etc etc.
So basically I want excell to look at all the words and export them to another list showing just unique keywords, 1 per line.
This is so I can see from a huge list what all the unique keywords are.
Is there a way of doing this within Excel Now?? or has someone made a plugin ( Macro) to achieve this?
I've looked at the sort & filter options, but it doesn't appear to have this function?
View 9 Replies
View Related
Mar 9, 2014
I'm looking to identify a keyword in a string and then replace that string with just the keyword.
The string is a product description. The keyword is a product group. The keyword can showup in any position in the string.
I can't post the actual data do to confidentiality requirements. but here's an example.
description
qty
price
keywords
code
green grapes bunch
1
2.5
[Code] .......
View 2 Replies
View Related
Apr 13, 2012
I have a list in column 1 that I would like to do an auto find and replace with the list in column two.
column a
big
fast
tough
mean
goofy
column a
"keyword" store
"keyword" stores
"keyword" stores.com
"Keyword" department store
store "keyword"
stores "Keyword"
View 2 Replies
View Related
Jan 24, 2008
I am trying to create my own budgeting tool. I have most of the tracker set up but I hit a stumbling block. I downloaded transations from Bank of America as a CSV file into excel. I want to categorize these transactions.
I created a keyword list that has words like "Starbucks" "Exxon" etc. Each of these keywords is then listed next to a category like "food" and "gas". So I want a formula that will compare the transactions to my keyword list and return the category type. Here is an example transaction:
CHECKCARD 0256 STARBUCKS USA 00029801 GAINESVILLE VA
I have a keyword "Starbucks" in f2 and "food" in g2.
View 9 Replies
View Related
Apr 3, 2013
So basically I have an Excel sheet which has keywords that need to be entered in Google search. I need the URL of the first page of the search result that appears after that keyword is entered. IS there a macro for the same?
View 3 Replies
View Related
Oct 22, 2009
Each product is represented by a serial number (column A).
The can be sorted on column A from smallest to largest prior to calculating results if that helps.
The repair list contains 1 entry per spare part used, so the same serial number may occur several times.
Furthermore, a product may have been repaired on several instances - so the serial numbers can span several dates (column B).
The solution i am looking for should return the number of unique repair dates per serial number. That way i can see, how many times each product has been repaired. Results can be displayed in an individual column.
Sample list:
Serial........Repair date
207742052008-09-04
207755082008-12-17
207755212008-12-31
207755212009-01-22
207755212009-01-22
207755212009-01-22
207755212009-02-13
207755212009-07-24
207755362009-05-20................................
View 8 Replies
View Related
Jul 30, 2009
I have a data table that repeats as follows:
CITI
SCB
SCB
SCB
SCB
SCB
SCB
SCB
RBC
RBC
RBC
RBC
From the data above I need to make a new unqie list that would grab all unique entries.
CITI
SCB
RBC
I am trying to use the following guide:
http://blogs.techrepublic.com.com/howdoi/?p=111
Get stuck on "Listing A:
View 9 Replies
View Related
Apr 18, 2013
I have my dummy data, and I have (what I think) is how I want the data to be shown. My friend uses Google Sheets, but I prefer Excel. I am trying to convert the code because I am a stickler for excel. Typically I can convert codes some easily, but this is way beyond me.
For Column A: I want to create a list on sheet 'Setup!' based on ids!D2:D="yes". If that list has duplicate entries, I would like only the first entry to show up, but for the next entries I would like the cell to be blank. (this is important for the next step) For Column C: I want to have the corresponding dates go with the name entry. For Column D: I want to have the notes go with the corresponding date entry. (I believe I can manipulate Column C's code to do Column D myself).
I am also going to upload a data sheet, and an expected results sheet.
unique list.xlsx
View 1 Replies
View Related
May 28, 2014
The function below should return the value in a cell IF the string in the cell two cells to the left of it is "Nemo" Omitting the part highlighted in blue, my function returns a list of unique values...but when it's included, nothing is returned at all. Perhaps, there is an error in the syntax that I'm overlooking?
Function listUnique(rng As Range) As Variant
Dim row As Range
Dim elements() As String
[Code]....
View 2 Replies
View Related
Oct 28, 2011
I'm looking for a way to get a unique list from a column to a data validation drop down list. Any fancy formula or vba script to create a UDF which. Does this?
View 5 Replies
View Related
May 23, 2009
I've searched the forum and believe this thread to be the closest to what im looking for, but its doesnt completely apply: matrix to list conversion. I have an attachment to support my questions (see attached). I have a matrix of words (strings) that contain repeating and non-repeating contents. The matrix also has spaces which are of no value. Essentially, the VBA needs to ' analyze' this matrix and create a consolidated frequency list (as shown in the file).
The matrices are HUGE and therefore some of the clumsy VBA i am using is turning out to be a bit inefficient. The file also contains formulas and such that I cannot use AutoFilter nor can I use Insert or Delete rows...so the VBA shouldnt use those either.
View 6 Replies
View Related
Jun 16, 2009
I have a dynamic list of names from B2:B500. I want to write a macro that finds all the unique entries from that list and pastes it to AD3:AD501 everytime the macro is run. What would be the code for this procedure.
View 9 Replies
View Related
Nov 28, 2007
I have a list of data which looks like this
Column B
Name
---------
Jones, Bob
Jones, Bob
Jones, Bob
Smith, Mike
Smith, Mike
Smith, Mike
Calai, Dave
Calai, Dave
Calai, Dave
Etc...
What I want to do is take the entire list and create a distinct list that I can use in a named range then use a validation list to have a drop down within a different tab.
View 9 Replies
View Related
Feb 26, 2013
Imagine this..
In Column A I have 500 email addresses.
In Column B I have 2000 email addresses.
Now in Column C, I want to have all the email addresses in Column B MINUS all the email addresses in Column A.
IE: So basically if Column B had 300 of the same email addresses in Column A, then Column C will have 1,700 email addresses (2,000 - 3000) = 1,7000.
View 1 Replies
View Related
Nov 27, 2013
I've got noticed "Sub or Function not defined". Here's the code:
VB:
Private Sub UserForm_Initialize()
' Abul Jibrin // November 2013
'------------------------
Dim Item As Range, UniqItem, n As Long
Set Tbl = Sheets("Sheet1").Cells(1, 2).CurrentRegion
Set Cabang = Tbl.Offset(2, 2).Resize(Tbl.Rows.Count - 2, 1)
[Code] ....
Note: I found that code :
Add item in combobox isn't using hardcoded but taking UniqueValue in column Item (which means using softcoded)
Unfortunately my friend's passed away so I can't continue asking him. I was trying to study his formula on my own but it still doesn't work at all
Here's the file : LIST OF UNIQUE VALUE.xlsm
View 9 Replies
View Related
May 28, 2008
I have a list of values in column A. How can I put a list of all the unique values contained in column A in a list format in column C?
I would prefer to use VBA code as to automate the process.
View 9 Replies
View Related
Jan 15, 2012
I got a column with dates like:
07/01/11
06/30/11
12/31/11
01/01/12
02/14/12
etc.
Now i'd like to populate a combobox with only unique years [i.e. 11 and 12]
View 8 Replies
View Related
Mar 20, 2013
I have a huge list of part numbers that has component part numbers listed as well. I am trying to take the list and make a list of Parent part number and identify the component part numbers that are used in all the parent part numbers. For example from the table below of the three parent part numbers there are only two parent part numbers have a component part in common 0011 and 0015 .I am looking for a fast way to create a list that looks like the example table two below.Parent Part Number
component Part Number
1000123
0011
1000123
0012
1000123
0013
[code]....
View 9 Replies
View Related
Oct 24, 2008
I have a column of names in Column D
I need code to list these names in column G
when I hit a button.
View 9 Replies
View Related
Nov 7, 2008
If I have in
column A
dog
cat
apple
orange
dog
apple
monkey
How Can I create a list that only selects unique values ie dog, cat, apple, orange monkey and displays in in column B
Also can it be a dynamic range so that if the list grew to 100 the validation would check all in the range?
View 9 Replies
View Related
Dec 23, 2008
I have the below table of data, in Column A there is a list of entries and there may be duplicates in them, what I want to do in column B is be able to list all the unique entries in there and basically remove any duplicates.
AB1DETAILED LISTUNIQUE LIST2Holden 3Ford 4BMW 5Mercedes 6Ford 7Ford 8Audi 9BMW 10Holden 11Ferarri 12Holden 13BMW 14Toyota 15Toyota
View 9 Replies
View Related
Jan 22, 2009
to calculate the count of unique text values from a list based on condition.
I have 2 columns A & B. In column A, I have Yes or NO text and in column B, I have Client names.
I want to count a list of unique values from column B if it is Yes in column A.
I have to write a formula to do this task and will appreciate any expert help in solving this.
View 9 Replies
View Related
Jun 15, 2009
I have a list of >50 contract numbers listed in cells A1:A350, with several of the numbers listed more than once. What I would like to do is, on a separate worksheet, list each contract number only once, in column A.
View 9 Replies
View Related
Jan 11, 2007
I was wondering if there is a formula or a vba code to return each number once from a list.
For example I’ve got a list with app. 500 rows and maybe 80 different numbers in there, so one number could be 50 times in the list, another number maybe just once. Is there a formula, which returns me each number once?
Can’t think of any, or do I have to use a vba code be get the information?
View 3 Replies
View Related
Jul 12, 2007
I have 2 columns of data on Sheet2. The first is Product in column B. The second is Benefit in column C.
I need to look at product column B on Sheet2 and add unique items to my first Combobox after the command Userform1.show.
The person using the form will select a product from Combobox1 and then Combobox2 should add the corresponding Benefits from the benefits column on Sheet2.
As a side note: I expect products and benefits will continue to be added to columns B and C in the future so I can't have a "hard-coded" set of rows if that makes sense.
I've pasted a small 2 product example of Sheet2 below.
ProductBenefit
Account DefenderLoss of Life
Account DefenderDisability
Account DefenderInvoluntary Unemployment
Account DefenderLeave of Absence
Account SecurityLoss of Life
Account SecurityDisability
Account SecurityInvoluntary Unemployment
Account SecurityLeave of Absence
Account SecurityHospitalization
Account SecurityNursing Home
View 8 Replies
View Related
Mar 10, 2008
I have two groups of data listed in one sheet. I have supplier names down the side and locations across the top, with data filling the respective cells. Refer excel file attached. At the moment I am manually merging the two lists to form one. I am copying both rows of headings and creating one unique row heading list, deleting any duplicates, then cutting and pasting the data under the respective heading. Because I am going to have to do this every month when new data comes in, I want to know whether their is a way to create a macro to automate this process...
View 2 Replies
View Related
Jun 20, 2008
I have a list of references and I need to pull from a database. The database contains more than one row with my reference, so I try doing something like this:
Sub ()
Range("B11").Select
Do Until IsEmpty(ActiveCell())
If ActiveCell = _
"7501" Or _
"7507" Or _
"7508" Or _
"7509" Or _
"7618" Then
But it does not work, besides I need to add more references. Could some one know a better way to do this?
View 3 Replies
View Related
Apr 16, 2013
I have a generated list that pulls data from a different sheet. I need a formula to pull only unique values from that generated list since some values are list multiple times.
[URL] ......
View 4 Replies
View Related
Apr 1, 2014
I would like a formula that will give me the unique list of items in Col A but will give them to me in alphabetical order. Sample list of data and desired result below.
List of ItemsDesired Result
Lamp Chair
Table Desk
Chair Filing Cabinet
Filing CabinetLamp
Lamp Phone
Desk Table
Phone
Chair
View 4 Replies
View Related
