Thanks Trunk, your suggestion worked fine. Elizabeth, I am aware that databases do this however they do not give the visability that spreadsheets provide, I am a db programmer and would normally use Access, thanks for your input as well.
I have an Excel 2000 spreadsheet where column a contains names of sites (unique), column b contains percentages of completion. I want to list in a single cell the names of the sites that match certain criteria. Example:<br>
a1-a5 contain Toledo, New York, Los Angeles, Atlanta, and Tulsa. b1-b5...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.