Another Excel question

[Kevy Baby]

Originally Posted by Alex

Are you confident that every time you have

Smith, John
Smith, John A
Smith, John Adam

that you'll want to delete the last two? Or do you need to evaluate and sometimes Smith, John A is actually a different person from Smith, John Adam so you need to keep both?

Doesn't matter. When the index is being created, if the first one is on page one, the second on page 2 and so on, I would get Index results showing:

Smith, John... 1, 2, 3
Smith, John A... 2, 3
Smith, John Adam... 3


Even though they may be "different" John Smiths, they would still be combined anyways. And the likelihood of different John Smiths (with the names I am dealing with) is pretty minimal and not worth worrying about.