Another Excel question

[Kevy Baby]

Originally Posted by Alex

So the index lists for each individual needs to be combined into a single list as well?

I think so (if I understand your question).

To expand on what I do with this. We create the body of this directory using FileMaker Pro and output it to a PDF document. There is no way within FMP (the way we are running this program) to capture the indexing data as we are running the directory. We found a program called Acrobotics PDF Index Creator, which takes a TXT file of the data to be found and processes it against the PDF file to find all instances of each record in the TXT file. I did try adding quote marks around each separate instance ("Smith, John" etc) but then it didn't find anything.

All data is cleaned in Excel before being imported into FMP which makes it simple for me to capture the name data for the TXT file.

That is why I am trying to suppress records in Excel.