Keyword search

Hello 4SF
I don't know how to have it narrow the search down as you type, but you can narrow a search down several other ways, inc, filters, using sub groups, search function, Ctrl F, pivot tables (I not clued up on pivot tables) and others. The search function requires clicking out of the input cell before "searching" begins.
I'm sure there is a way using VBA, but again I'm happy to record a macro, but I don't understand the writing of it.
How big is the list, is it static?
I have spread sheets with 30,000 rows on them and can brake them down to a couple very quickly.
Regards
Peter
Why not attach a dummy copy of what you want

Hello peter

I have attached part of the actual list. The whole list is static and in the order of 3000 rows in one single column. Note: word/s in each row resides in one cell only.

Monomethylarsonic Acid
% Ash (Dried Sample)
% Ash (As Received Sample)
Dibutyl Tin
Mg meq
Hydrogen Fluoride (HF)
Magnesium Mg^++
Ignition Temperature
% LOI (Dried Sample)
% LOI (as received)
Monobutyl Tin
% Moisture
Drying Temperature (Ash/LOI)
Purity H^^2SiF^^6
Purity Na^^2SiF^^6
Sieve Type
Tribuyl Tin
Temperature for Drying
Chromium (III) by difference
Mole Ratio*
MPN Coliforms
MPN E. coli
Conductivity Flood Water
Ionic Strength
Sodium Absorp. Ratio*
Hypophosphite (PO2)
Orthophosphite (PO3)
Report SWA results
Turbidity Flood Water
TSS Flood Water
Zinc
MW Report Comments
Clostridium perfringens (Treated)
Cryptosporidium oocysts
Free Chlorine (Micro Water)
Giardia cysts
Micro Waters Flag
Total Chlorine (Micro Water)
Water Micro Comment
Start Time/Date
Turbidity (Water)
Sample Blank
Sample Counts
Sample Corrected Counts
Monitor Element Concentration
Monitor Element
Monitor Blank
Monitor Counts
Blank Corrected Counts
XRF Scan Major Components
XRF Scan Minor Components
Aluminium by XRF Semi Qualitative
Arsenic by XRF Semi-Qualitative
Barium by XRF Semi-Qualitative
Bismuth by XRF Semi Qualitative
Bromine by XRF Semi-Qualitative
Calcium by XRF Semi-Qualitative
Cadmium by XRF Semi-Qualitative
Cerium by XRF Semi-Qualitative
Chloride by XRF Semi-Qualitative
Cobalt by XRF Semi-Qualitative
Chromium by XRF Semi-Qualitative
Cesium by XRF Semi-Qualitative
Copper by XRF Semi-Qualitative
Dysprosium by XRF Semi-Qualitative
Iron by XRF Semi-Qualitative
Gallium by XRF Semi-Qualitative
Gadolinium by XRF Semi-Qualitative
Germanium by XRF Semi-Qualitative
Hafnium by XRF Semi-Qualitative
Mercury by XRF Semi-Qualitative
Iodide by XRF Semi-Qualitative
Potassium by XRF Semi-Qualitative
Lanthanum by XRF Semi-Qualitative
Magnesium by XRF Semi-Qualitative
Manganese by XRF Semi-Qualitative
Molybdenum by XRF Semi-Qualitative
Sodium by XRF Semi-Qualitative
Niobium by XRFSemi- Qualitative
Neodymium by XRF Semi-Qualitative
Nickel by XRF Semi-Qualitative
XRF Scan Comment
Phosporous by XRF Semi-Qualitative
Lead by XRF Semi-Qualitative
Praesodium by XRF Semi-Qualitative
Rubidium by XRF Semi-Qualitative
Sulphur by XRF Semi-Qualitative
Antimony by XRF Semi-Qualitative
Scandium by XRF Semi-Qualitative
Selenium by XRF Semi-Qualitative
Silica by XRF Semi-Qualitative
Samarium by XRF Semi-Qualitative
Tin by XRF Semi-Qualitative
Strontium by XRF Semi-Qualitative
Tantallum by XRF Semi-Qualitative
Terbium by XRF Semi-Qualitative
Thorium by XRF Semi-Qualitative
Titanium by XRF Semi-Qualitative
Thallium by XRF Semi-Qualitative
Uranium by XRF Semi-Qualitative
Vanadium by XRF Semi-Qualitative
Tungsten by XRF Semi-Qualitative
Ytterbium by XRF Semi-Qualitative
Zinc by XRF Semi-Qualitative
Zirconium by XRF Semi-Qualitative
XRF Scan Trace Components
Word Document for Inorganics
NaHCO3 - calculated
Na Meq

Hello Peter

Could not find the attachment button before. I attach the list as a file this time

G'day 4sf

Please have a look at this.
You will have to ENABLE MACROS, once open you can add the rest of the data to the list, push the SORT LIST button.
Or key into the green cell the word you are searching for and press the FIND button, and I figure you may be able to figure out what the reset button is for.
If you macro settings are to low,I assume you have 2003 change them by going to TOOLS,
OPTIONS, MACRO SECURITY, and set it to medium, so you can choose to allow a macro or not.
If for what ever reason you don't want to ENABLE MACROS you can still manually DATA SORT,and the FIND is just selecting the filter, and the RESET is just unselecting the filter.
The search formula has nothing to do with macros. Just remember to use the GREEN CELL IS INPUT.
You could also protect the sheet so you can't accedently stuff the formulas up, but allow you to select just that cell and to USE FILTER.
Regards
Peter

Hello Peter

Thanks for the very thorough reply. I will give it a go to see if it fits in with what I am doing. At least this is a start for me. Will keep you informed.

No probs
Regards
Peter

John

Thanks. I will give it a go.

John/Peter
Thanks for the suggestions and ideas. I adapted and plagiarised your ideas and codes to get it to work the way I wanted.