Keyword Finder - Using An Old Thread For A New
May 5, 2009
I am similarly interested in using the logic in this thread http://www.excelforum.com/excel-prog...uplicates.html
Basically I want to be able to type in a keyword and then bring up a number of matching results along with their associated code.
Using the spreadsheet in the above thread, I tried to add an extra entry as a test, as my database contains roughly ~1500 entries, but excel doesn't seem to like me adding 1 more entry and adjusting the dimensions of the code?
View 2 Replies
ADVERTISEMENT
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
Jul 7, 2008
if there is a way of creating a macro to do the following:
Find the number of times a name ocurrs in a column and then on a different sheet in the same workbook, place the number of times into a different column. Preferably without making the first column the same one each time, although this is not a problem.
Therefore if the name Smith appears 5 times in sheet 2 column c then it will place the number 5 in column H cell 2 in sheet 1, and so on down the list of names. Obviously the cells in sheet 1 will change for each person's name.
I suspect that it will involve VLOOKUP, but I'm not well versed enough in Excel to get it right.
I need to do this for multiple names.
View 9 Replies
View Related
May 24, 2014
How to search words puzzle quickly using conditional formatting in excel?
View 7 Replies
View Related
Apr 18, 2014
In an excel sheet, i have columns as below:
Column: A B C D
Values assigned & Formula Used : 1 2 3 (A+B+C)
There are lots of cells, where i used various formulas that includes the value of Column D as specified above.
Example:
In Column E as "D*3" or Column Z as "D-E".
Now, i want to trace in the whole excel sheet, where i used column D in Formulas, i put through.
View 7 Replies
View Related
Jul 11, 2014
pull out just the date from this thread: 01/01/14 0919
View 5 Replies
View Related
Feb 13, 2009
how do i mark a thread closed? I looked in tools and lots of other places?
View 4 Replies
View Related
May 7, 2009
btw i saw following soloved post but i didnt get the question and answer.
can u provide examples?
http://www.excelforum.com/excel-misc...ard-count.html
View 2 Replies
View Related
Sep 22, 2013
I have found no option here to attache file (excel, or word if any). How to attach file in to create a new thread ?
View 1 Replies
View Related
Nov 4, 2009
XYZ001
XYZ002XYZ003
XYZ004XYZ003XYZ004XYZ001XYZ002XYZ004
I have data in above format (including Dup). Is there anyway I can get the postion of latest entry. say if it is xyz011, it should return 8. Match will start counting from first cell and go downward. How can do a inverse counting?
View 9 Replies
View Related
Jan 2, 2013
how to open another thread. I would like to do a survey form (as attached) but I wanted to use VBA to make it easy to compute the result.
View 2 Replies
View Related
Jan 11, 2009
If it is possible to do, how do I change this message format to html so that I can paste an image into the message?
View 5 Replies
View Related
Nov 14, 2008
I'm quite newbie for VBA for excel, my friend asked me a favor to filter the data on his excel, so when he enter some keyword, the table would sorted (only show the row that have that keyword), and if possible that he enter it few keyword.
keyword example VB, oracle
table example ....
View 10 Replies
View Related
Mar 19, 2014
I'm trying to extract the number of times specific keywords are used in Sheet1 and display that number on Sheet2.
For example:
Keywords to be used
ni = not interested
appt = appointment
na = not available
If ni is used 10 times, appt is uesd 2 times and na used 6 times.
I want to be able to see those numbers on Sheet2 next to the keywords.
e.g;
ni = 10
appt = 2
na = 6
View 2 Replies
View Related
Feb 8, 2014
Code / macro that would automatically search a word doc for keywords and export every instance of that keyword into column A of a spreadsheet, the first three or four words prior to that keywords into column B, and the entire sentence where the keywords is found into column C?
I often pull hundreds of pages of text from a program that exports into Word and have to look through the pages to find every instance where a point is referenced by geolocation. Then I have to filter through that data to determine which of the points I found are truly important before I save it all to a csv or xls and feed it into mapping software.
If I had a code / macro that did the search and export automatically, it would save hours of work.
View 5 Replies
View Related
Jan 14, 2010
I have a work sheet called 'Cross Ref data' which I want to put a keyword in column A (row 1,2,3,4,5,6,7,8 etc)
I then want to be able to run a macro that will grab the contents of A1 in WS called 'Cross Ref data' and check if it appears in column D and E in WS 'Results'
If there is a match then for the entire line within WS 'Results' be copied to a WS that already exists called "Cross Ref Results" (please see the below heading '88888***********8888' for the layout) .........
View 14 Replies
View Related
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
View Related
Mar 15, 2009
I would like to have a macro to loop through all the worksheet except for "Summary" worksheet.
The macro will look for the keyword in the worksheet starting from row 2 from every sheet.
if the keyword is found on the row, the entire row will be deleted and shift row up.
Keyword for example is found in H13 in the Summary worksheet
Summary
GH13KeywordLondon
Excel tables to the web >> Excel Jeanie HTML 4
View 9 Replies
View Related
Aug 31, 2007
I have 4 macros which inserts a row in workbook (at specific interval of time). These macros run in a endless loop. The problem arises if any other workbook is open and active at the same time. The macro tries to update this active workbook.
Can I ensure that macro runs for only specific workbook (whether the workbook is active or not)
Option Explicit
Public RunWhen As Double
Public RunWhat As String
Dim wCount
Sub Macro3()
'Initialize counter
wCount = 100
Call Macro4
End Sub
Sub Macro4()
If wCount > 0 Then
' If counter greater than zero then update excel with counter and
' call macro to decrease the counter
Cells(1, 2).Value = wCount
RunWhat = "Macro5"...................
View 2 Replies
View Related
Sep 20, 2007
I probably just am just missing a Library but when I type "Selection." I would normally expect Autocomplete to pop up telling me that I am able to choose from Cut, Paste, ect. However its it almost as of my VBA editor does not recognize Selection as a proper object.
I have the following Reference Library's loaded:
Visual Basic For Applications
Microsoft Excel 11.0 Object Library
OLE Automation
Microsoft Office 11.0 Object Library
Microsoft Outlook 11.0 Object Library
View 6 Replies
View Related
Jun 21, 2008
I am looking to write a macro that will search for keywords on a sheet, on a workbook at a specific path, and would like some help getting this macro started...
It would get run from "WorkbookA", and would look at "WorkbookB" (wherever it is) and find the cell containing the keyword, where the cell value would be the output. I would really prefer that it did not open Workbook B while this macro is run, if thats possible.
View 5 Replies
View Related
Dec 6, 2012
I am looking to automatically assign products to a relevant categories on my website and I am working on a spreadsheet. Each category is has a four digit number assigned to it and categories are limited to 3 (Primary, Secondary & Tipperary)
For example:
Computers - 1000 - Desktops - 1100 - Dual Core PC - 1101
Computers - 1000 - Desktops - 1100 - Quad Core PC - 1102
So as you can see you can tell a Dual Core PC is in the Computer & Desktop categories just by looking at the first two digits. The last two digits are the category number. 01, 02, 03 etc.
What I wish to do is associate keywords to the category determine which category that product should be assigned.
Product ID
Product Title
Product Description
Product Spec1
Product Spec2
1
HP Desktop PC
HP Desktop PC's are computers
Intel Dual Core Processor
500GB HDD
2
HP Desktop PC
HP Desktop PC's are computers
Intel Quad Core Processor
1TB HDD
Keywords assigned to category 1101 are Computers, Computer, PC, Desktop, Dual Core.
Keywords assigned to category 1102 are Computers, Computer, PC, Desktop, Quad Core.
And the spreadsheet looks like this:
The script/sum would look at all the cells and match the highest count of keywords to that particular category and populate additional fields called Cat1, Cat2 & Cat3. Therefore the final spreadsheet would look like this:
Product ID
Product Title
Product Description
Product Spec1
Product Spec2
Cat1
Cat2
Cat3
1
HP Desktop PC
HP Desktop PC's are computers
Intel Dual Core Processor
500GB HDD
1000
1100
1101
2
HP Desktop PC
HP Desktop PC's are computers
Intel Quad Core Processor
1TB HDD
1000
1100
1102
How this can be implemented? possibility with the use of VLOOKUP or MATCH commands?
I believe a vlookup would be fine but there's was only 1 value to match but as it's multiples it would need to prioritise based on the number of keywords matched and not just the first match found.
[URL] .......
View 4 Replies
View Related
Sep 30, 2008
Attached is a spreadsheet describing my problem in greater detail, but essentially i want to extract rows of data depending on quoter name. I'm fairly competent with excel formulae, but cannot get the desired results. I know nothing of VBA other than copying and pasting other's VBA projects in and fiddling with them until something good happens!!
I wish to extract the data and deposit into another worksheet or better still another workbook entirely but without any breaks in the rows of data.
Havent had much luck with advanced filter either.
View 14 Replies
View Related
Nov 18, 2009
Am I right to say that "Call" is not mandatory and should be used only to invoke subroutines that do not return a value?
If you use the keyword "Call" to invoke a subroutine that does return something, the returned variable will be discarded.
View 10 Replies
View Related
Apr 18, 2013
Currently I am using excel 2007. In that I have two sheets (sheet1 as Dashboard & Sheet2 as Database). On sheet1 I need to develop a functionality of searching as per key word (Keyword will be typed on cell B2) and i need to display search data below cell B2 till whatever cells depending as per database.
View 3 Replies
View Related
Jul 23, 2014
So I have data that I'm importing in rows 1,2 and 3. The first row has the product type, then rows 2 and 3 have additional info pertaining to that product. I was wondering how I would write a macro that could identify entries in the first row that equal a particular product, and remove those cells, along with its respective info in rows 2 and 3. Ideally, I could just push a button, and a particular product along with all it's info would disappear from my imported table.
View 4 Replies
View Related
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 3, 2008
i'm writing a few VB subs to help manage a database of mishaps, solutions and lessons learned, there are 11 columns and each databade entry has a separate row, there are approximately 1,000 rows.
Columns are:
ID- a unique iderntifier for each entry- integer
Date- date the entry was made- date
Project Number- a reference to an internal project file- string
Operator- company we were working for- string
Installation- where the work took place- string
Category- type of problem encountered- string
Application- field of problem encountered- string
Issue- string
Background- string
Problems- string
Lessons Learned- string...........
View 9 Replies
View Related
Jul 7, 2009
I have a sheet with 3 ranges of data in Sheet4, being partcode (B20:B20000), description (C20:C20000) and price (D20:D20000).
What I'd like is a macro to take a keyword entered in Sheet4!C17, search the whole range (B20:D20000), and hide the rows that don't contain the keyword.
Autofilter would be the logical method to my way of thinking, but can that work with a keyword entered in a cell, and can it all be hidden in a macro behind a control button?
View 9 Replies
View Related
Oct 30, 2009
I am trying to set up a keyword search where someone can type a word in D8 and the number of books with that word in its title will be returned.
I have managed to get the following sum to work if I put the exact title in the search however I would like it to be possible for a partial search.
=SUMPRODUCT(--('Books List'!G2:G1166=D8))
View 9 Replies
View Related
