Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making a selection while using a formula in case of redundant records?
Hi there!,
I am having difficulties with the following spreadsheet. In worksheet 2 I stuffed a database with names and telephonenumbers (divided over 3 colums) Example A1 B1 C1 Surname Full name Telnr Aa F.C. van der Aa 9745 Aa M.H. van der Aa 7145 Aa V.P. van de Aa-Mei 3421 This databases comprises 2500 records. In worksheet 1 I use the cells in one column as inputvalue, whereas this value is looked up within the database. The problem is possible redundancy in column 1 of the database, which may contain more than one surname that is exactly the same (e.g : Aa exists 3 times!) The problem might be solved in worksheet 1 by validating the cells in the ïnput-column". However: the list that appears in each cell comtains 2500 items and hence this is not a very practical way of choosing the right name from a list. Is there another solution (no VBA-solution please) Regards, Ruud |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making all text become lower case | Excel Discussion (Misc queries) | |||
How can I delete redundant records in Excel without then leaving b | Excel Discussion (Misc queries) | |||
Making Sheet all Upper Case | Excel Discussion (Misc queries) | |||
Making a C++ like if statment case for excel in VBA | Excel Programming | |||
Making a cell's contents lower case | Excel Worksheet Functions |