Thread
:
Searching for text
View Single Post
#
2
Posted to microsoft.public.excel.misc
Ardus Petus
Posts: n/a
Searching for text
110k 65536, so Excel will not hold your names list
--
AP
"strippier" a écrit dans le message de
news:
...
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
Reply With Quote