I would think a macro that eliminates those other records and puts the phone
numbers on the first (and only) record to keep would be easier than a formlua.

If that sounds interesting, you'll have to describe your data (key field is
column ??). Phone numbers are in column ??.

And what does merge mean? Use one cell that contains all the phone numbers
(could be a problem later on) or dedicate columns (say) M:P for phone
numbers--limit 4 per person???



CCharley wrote:

I am looking for a formula for an "if / then" scenario. I have a
database where each record is duplicated based on a change in
the data in one field. For example, if the person has 3 different phone
numbers, then the subject's record would appear 3 times, with the only
difference between each record appearing in the phone number column.

I am trying to write a formula stating if the person's name is the same,
then merge the phone number fields. I have tried several different things
(including pivot tables, which don't work because there are too many
columns/rows of data) and can't seem to get it to work. Any help would be
appreciated.

--

Dave Peterson