I have a pretty frustrating problem in Excel 2010. On my worksheet, each row has a cell for "name of deceased" (in my xls its relegated to column B), First Name of certain relative (column E) and Last Name of same relative (column F). I want to concatenate all of the OTHER relative's names in one new cell for each row. I spent all day yesterday working on this and any help will be hugely appreciated.
Basically, what I'm trying to do is create a new column that lists, for every row, the first and last names of Column B's (the name of deceased) relatives. All of this data is in one spreadsheet.
Thanks a Bunch Gang.
Tilu
Bookmarks