| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to add data to a column based on criteria from another
I have two columns one with a single employee id and the second column is the
employee name for several rows something like this: 1234 John Doe John Doe John Doe 3456 Jane Doe Jane Doe Jane Doe How do I move the employee number down to coincide with its name and then start the next employee and do the same thing without manually copying and pasting. |
|
#2
|
|||
|
|||
|
If your data is exactly as the example you posted, try this old trick:
Select the column of employee ID's, then: Hit F5 Click "Special" Click "Blanks" Then <OK Type the Equal (=) sign Hit the UpArrow Hit <Ctrl <Enter -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Lynn Bales" <Lynn wrote in message ... I have two columns one with a single employee id and the second column is the employee name for several rows something like this: 1234 John Doe John Doe John Doe 3456 Jane Doe Jane Doe Jane Doe How do I move the employee number down to coincide with its name and then start the next employee and do the same thing without manually copying and pasting. |
|
#3
|
|||
|
|||
|
Worked like a charm, except I didn't notice blank rows between each employee.
Is there a way to delete blank rows easily? I know these are basic questions I'm just new to using the app. Thanks so much! "RagDyeR" wrote: If your data is exactly as the example you posted, try this old trick: Select the column of employee ID's, then: Hit F5 Click "Special" Click "Blanks" Then <OK Type the Equal (=) sign Hit the UpArrow Hit <Ctrl <Enter -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Lynn Bales" <Lynn wrote in message ... I have two columns one with a single employee id and the second column is the employee name for several rows something like this: 1234 John Doe John Doe John Doe 3456 Jane Doe Jane Doe Jane Doe How do I move the employee number down to coincide with its name and then start the next employee and do the same thing without manually copying and pasting. |
|
#4
|
|||
|
|||
|
Nevermind I found in by doing a search. Thanks so much, RagDyeR.
"Lynn Bales" wrote: Worked like a charm, except I didn't notice blank rows between each employee. Is there a way to delete blank rows easily? I know these are basic questions I'm just new to using the app. Thanks so much! "RagDyeR" wrote: If your data is exactly as the example you posted, try this old trick: Select the column of employee ID's, then: Hit F5 Click "Special" Click "Blanks" Then <OK Type the Equal (=) sign Hit the UpArrow Hit <Ctrl <Enter -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Lynn Bales" <Lynn wrote in message ... I have two columns one with a single employee id and the second column is the employee name for several rows something like this: 1234 John Doe John Doe John Doe 3456 Jane Doe Jane Doe Jane Doe How do I move the employee number down to coincide with its name and then start the next employee and do the same thing without manually copying and pasting. |
|
#5
|
|||
|
|||
|
Appreciate the feed-back.
And would you mind sharing your solution with the group? Others might very well benefit from the information posted here, just as you did. -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "Lynn Bales" wrote in message ... Nevermind I found in by doing a search. Thanks so much, RagDyeR. "Lynn Bales" wrote: Worked like a charm, except I didn't notice blank rows between each employee. Is there a way to delete blank rows easily? I know these are basic questions I'm just new to using the app. Thanks so much! "RagDyeR" wrote: If your data is exactly as the example you posted, try this old trick: Select the column of employee ID's, then: Hit F5 Click "Special" Click "Blanks" Then <OK Type the Equal (=) sign Hit the UpArrow Hit <Ctrl <Enter -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Lynn Bales" <Lynn wrote in message ... I have two columns one with a single employee id and the second column is the employee name for several rows something like this: 1234 John Doe John Doe John Doe 3456 Jane Doe Jane Doe Jane Doe How do I move the employee number down to coincide with its name and then start the next employee and do the same thing without manually copying and pasting. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining workbooks with some variable field names | Excel Discussion (Misc queries) | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Count cells based on date range in another column | New Users to Excel | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
Linear Mode
