#1   Report Post  
Old May 23rd 06, 03:01 PM posted to microsoft.public.excel.misc
strippier
 
Posts: n/a
Default Searching for text

Hiya,

I have a list of names (approx 110,000) which I need to search for specifc
names (approx 1000).

eg A = list of 110k names / C = search criteria 1000 names / B = found Y or N
Column A Column B Column C
Mr Smith Y Smith
RC Jones N Trip
S Abdul Y Abdu
R Basil N
etc

It needs to use the C list of names and show where these exist in the column
A list, putting the results in column B.

I deally I would like a % match, i.e. smith contanied 100% within Mr Smith,
but only 60% within Mr Smithson etc.

Any ideas?

Thanks for you time.

Simon

  #3   Report Post  
Old May 23rd 06, 09:08 PM posted to microsoft.public.excel.misc
mrice
 
Posts: n/a
Default Searching for text


I would suggest that you save your list of 110K names in a .txt file.

Then put your 1000 names in Excel.

Read in the text file line by line using something like

open "C:\Myfile.txt" for input as #1
Do while not EOF(1)
Line input #1, FileLine
For Each Cell in Range(Cells(1,1),Cells(1000,1))
If Cell = FileLine then Cell.offset(0,1) = Cell.offset(0,1)+1
Next Cell
Loop
Close #1

It will probably take quite a while to run.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=544700



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Want a serious muslim match?Join our club and start searching now!!! [email protected] Excel Worksheet Functions 0 May 17th 06 07:47 AM
Want a serious muslim match?Join our club and start searching now!!! [email protected] Excel Discussion (Misc queries) 0 May 17th 06 07:47 AM
Want a serious muslim match?Join our club and start searching now!!! [email protected] Excel Worksheet Functions 0 May 17th 06 07:25 AM
cell background color while searching through cells MatthewTap Excel Discussion (Misc queries) 1 January 17th 06 08:00 PM
Searching for partial data in a column Severin Excel Discussion (Misc queries) 2 October 3rd 05 06:33 PM


All times are GMT +1. The time now is 07:48 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright ©2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017