| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Problem - When couples have different last names
I'm a Newbie. Church secretary died, no one knows how to use database as is. I have re-entered data from scratch in new worksheet - all of it! Because many couples do not share same last name, it was suggested that I create these columns First_Name1, Last_Name1, AND, (actually a column containing the conjunction "and") First_Name2, Last_Name2. This design was based on creating mailing labels and a directory. To have it work in printing labes, etc, I was to leave Last_Name1 blank if the couple shared the same last name. A limited test was positive with data imported by word for mailing labels - or did they export to Word? - I am so green!. Since the test, I have added new names to the database. I just did them all at the bottom of the worksheet assuming I could sort the whole database alphabetically when done. I was looking for a way to sort by Last name. Since there are single members, the column I would have to use is Last_Name1 column - so I'm sure you are far ahead of me in seeing the flaws in this setup and can possibly understand my state of panic at this point. Trudy  -- lburg801 ------------------------------------------------------------------------ lburg801's Profile: http://www.excelforum.com/member.php...o&userid=28338 View this thread: http://www.excelforum.com/showthread...hreadid=479579 |
|
#3
|
|||
|
|||
|
Problem - When couples have different last names
You could use a 'helper' column to sort by... for example
A:First_Name1, B:Last_Name1, C:AND, D:First_Name2, E:Last_Name2, F:SORT F:=if(isblank(B1),E1,B1) and copy it down the column. This will put Last_Name1 in F if it exists and Last_Name2 if it does not. Note: the = sign needs to be at the beggining of the formula I think this is the easiest way that you won't have to rework the whole spreadsheet...again. "Don Guillett" wrote: Without too much thought how about a column for the couple and another column on the SAME row if there are two Brown, Joe Betty Brown, Joe Smith, Ann then you could use =a2 & " " & b2 -- Don Guillett SalesAid Software "lburg801" wrote in message ... I'm a Newbie. Church secretary died, no one knows how to use database as is. I have re-entered data from scratch in new worksheet - all of it! Because many couples do not share same last name, it was suggested that I create these columns First_Name1, Last_Name1, AND, (actually a column containing the conjunction "and") First_Name2, Last_Name2. This design was based on creating mailing labels and a directory. To have it work in printing labes, etc, I was to leave Last_Name1 blank if the couple shared the same last name. A limited test was positive with data imported by word for mailing labels - or did they export to Word? - I am so green!. Since the test, I have added new names to the database. I just did them all at the bottom of the worksheet assuming I could sort the whole database alphabetically when done. I was looking for a way to sort by Last name. Since there are single members, the column I would have to use is Last_Name1 column - so I'm sure you are far ahead of me in seeing the flaws in this setup and can possibly understand my state of panic at this point. Trudy -- lburg801 ------------------------------------------------------------------------ lburg801's Profile: http://www.excelforum.com/member.php...o&userid=28338 View this thread: http://www.excelforum.com/showthread...hreadid=479579 |
|
#4
|
|||
|
|||
|
Problem - When couples have different last names
IS THERE A WAY TO FORMAT THE WHOLE COLUMN OR DO I HAVE TO CHANGE THE CELL NUMBERS AND APPLY IT TO EACH CELL IN THE COLUMN? Search33 Wrote:[color=blue] You could use a 'helper' column to sort by... for example A:First_Name1, B:Last_Name1, C:AND, D:First_Name2, E:Last_Name2, F:SORT F:=if(isblank(B1),E1,B1) and copy it down the column. This will put Last_Name1 in F if it exists and Last_Name2 if it does not. Note: the = sign needs to be at the beggining of the formula I think this is the easiest way that you won't have to rework the whole spreadsheet...again. "Don Guillett" wrote: Without too much thought how about a column for the couple and another column on the SAME row if there are two Brown, Joe Betty Brown, Joe Smith, Ann then you could use =a2 & " " & b2 -- Don Guillett SalesAid Software "lburg801" wrote in message ... I'm a Newbie. Church secretary died, no one knows how to use database as is. I have re-entered data from scratch in new worksheet - all of it! Because many couples do not share same last name, it was suggested that I create these columns First_Name1, Last_Name1, AND, (actually a column containing the conjunction "and") First_Name2, Last_Name2. This design was based on creating mailing labels and a directory. To have it work in printing labes, etc, I was to leave Last_Name1 blank if the couple shared the same last name. A limited test was positive with data imported by word for mailing labels - or did they export to Word? - I am so green!. Since the test, I have added new names to the database. I just did them all at the bottom of the worksheet assuming I could sort the whole database alphabetically when done. I was looking for a way to sort by Last name. Since there are single members, the column I would have to use is Last_Name1 column - so I'm sure you are far ahead of me in seeing the flaws in this setup and can possibly understand my state of panic at this point. Trudy -- lburg801 ------------------------------------------------------------------------ lburg801's Profile: http://www.excelforum.com/member.php...o&userid=28338 View this thread: http://www.excelforum.com/showthread...hreadid=479579 IS THERE A WAY TO FORMAT THE WHOLE COLUMN OR DO I HAVE TO CHANGE THE CELL NUMBERS AND APPLY IT TO EACH CELL IN THE COLUMN? -- lburg801 ------------------------------------------------------------------------ lburg801's Profile: http://www.excelforum.com/member.php...o&userid=28338 View this thread: http://www.excelforum.com/showthread...hreadid=479579 |
|
#5
|
|||
|
|||
|
Problem - When couples have different last names
Please don't SHOUT! It is considered to be bad netiquette.
Yes, click on the A or B or ? and then format. -- Don Guillett SalesAid Software "lburg801" wrote in message ... IS THERE A WAY TO FORMAT THE WHOLE COLUMN OR DO I HAVE TO CHANGE THE CELL NUMBERS AND APPLY IT TO EACH CELL IN THE COLUMN? Search33 Wrote: You could use a 'helper' column to sort by... for example A:First_Name1, B:Last_Name1, C:AND, D:First_Name2, E:Last_Name2, F:SORT F:=if(isblank(B1),E1,B1) and copy it down the column. This will put Last_Name1 in F if it exists and Last_Name2 if it does not. Note: the = sign needs to be at the beggining of the formula I think this is the easiest way that you won't have to rework the whole spreadsheet...again. "Don Guillett" wrote: Without too much thought how about a column for the couple and another column on the SAME row if there are two Brown, Joe Betty Brown, Joe Smith, Ann then you could use =a2 & " " & b2 -- Don Guillett SalesAid Software "lburg801" wrote in message ...[color=green] I'm a Newbie. Church secretary died, no one knows how to use database as is. I have re-entered data from scratch in new worksheet - all of it! Because many couples do not share same last name, it was suggested that I create these columns First_Name1, Last_Name1, AND, (actually a column containing the conjunction "and") First_Name2, Last_Name2. This design was based on creating mailing labels and a directory. To have it work in printing labes, etc, I was to leave Last_Name1 blank if the couple shared the same last name. A limited test was positive with data imported by word for mailing labels - or did they export to Word? - I am so green!. Since the test, I have added new names to the database. I just did them all at the bottom of the worksheet assuming I could sort the whole database alphabetically when done. I was looking for a way to sort by Last name. Since there are single members, the column I would have to use is Last_Name1 column - so I'm sure you are far ahead of me in seeing the flaws in this setup and can possibly understand my state of panic at this point. Trudy -- lburg801 ------------------------------------------------------------------------ lburg801's Profile: http://www.excelforum.com/member.php...o&userid=28338 View this thread: http://www.excelforum.com/showthread...hreadid=479579 IS THERE A WAY TO FORMAT THE WHOLE COLUMN OR DO I HAVE TO CHANGE THE CELL NUMBERS AND APPLY IT TO EACH CELL IN THE COLUMN? -- lburg801 ------------------------------------------------------------------------ lburg801's Profile: http://www.excelforum.com/member.php...o&userid=28338 View this thread: http://www.excelforum.com/showthread...hreadid=479579 |
|
#6
|
|||
|
|||
|
Problem - When couples have different last names
Don, I gather that my experimenting with font sizes is equated with shouting. I have some difficulty finding the new post, so it was more about me being confused. Pardon my netiquette faux pas. I need a blushing smilie to paste here. Also, I may have used the wrong term when I said format. My question is there a way to apply a formula like the example you gave, since it refers to specific cells, to an entire column? Thanks again, Trudy Don Guillett Wrote:[color=blue] Please don't SHOUT! It is considered to be bad netiquette. Yes, click on the A or B or ? and then format. -- Don Guillett SalesAid Software "lburg801" wrote in message ... IS THERE A WAY TO FORMAT THE WHOLE COLUMN OR DO I HAVE TO CHANGE THE CELL NUMBERS AND APPLY IT TO EACH CELL IN THE COLUMN? Search33 Wrote: You could use a 'helper' column to sort by... for example A:First_Name1, B:Last_Name1, C:AND, D:First_Name2, E:Last_Name2, F:SORT F:=if(isblank(B1),E1,B1) and copy it down the column. This will put Last_Name1 in F if it exists and Last_Name2 if it does not. Note: the = sign needs to be at the beggining of the formula I think this is the easiest way that you won't have to rework the whole spreadsheet...again. "Don Guillett" wrote: Without too much thought how about a column for the couple and another column on the SAME row if there are two Brown, Joe Betty Brown, Joe Smith, Ann then you could use =a2 & " " & b2 -- Don Guillett SalesAid Software "lburg801" wrote in message ... I'm a Newbie. Church secretary died, no one knows how to use database as is. I have re-entered data from scratch in new worksheet - all of it! Because many couples do not share same last name, it was suggested that I create these columns First_Name1, Last_Name1, AND, (actually a column containing the conjunction "and") First_Name2, Last_Name2. This design was based on creating mailing labels and a directory. To have it work in printing labes, etc, I was to leave Last_Name1 blank if the couple shared the same last name. A limited test was positive with data imported by word for mailing labels - or did they export to Word? - I am so green!. Since the test, I have added new names to the database. I just did them all at the bottom of the worksheet assuming I could sort the whole database alphabetically when done. I was looking for a way to sort by Last name. Since there are single members, the column I would have to use is Last_Name1 column - so I'm sure you are far ahead of me in seeing the flaws in this setup and can possibly understand my state of panic at this point. Trudy -- lburg801 ------------------------------------------------------------------------ lburg801's Profile: http://www.excelforum.com/member.php...o&userid=28338 View this thread: http://www.excelforum.com/showthread...hreadid=479579 IS THERE A WAY TO FORMAT THE WHOLE COLUMN OR DO I HAVE TO CHANGE THE CELL NUMBERS AND APPLY IT TO EACH CELL IN THE COLUMN? -- lburg801 ------------------------------------------------------------------------ lburg801's Profile: http://www.excelforum.com/member.php...o&userid=28338 View this thread: http://www.excelforum.com/showthread...hreadid=479579 -- lburg801 ------------------------------------------------------------------------ lburg801's Profile: http://www.excelforum.com/member.php...o&userid=28338 View this thread: http://www.excelforum.com/showthread...hreadid=479579 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| filter 400 names from list 1 from list 2 with 4000 names | Excel Worksheet Functions | |||
| find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
| Replace range names with cell references? | Excel Worksheet Functions | |||
| Finding Duplicate Names from Different Lists... | Excel Discussion (Misc queries) | |||
| Baffling formula problem | Excel Discussion (Misc queries) | |||
Hybrid Mode
