Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default excel - Taking a list of people and adding them to 2 columns

hi i have a list of people on column A and wish to copy 1 person from the
list and work down and add them to a diff column. eg
Albert
Andrew
Betty
Bill
Craig
Paul

would i be able to do the following
G K
Albert Andrew
Betty Bill
Craig Paul

also i would liike it if i added a new person it would add it to the next
blank space

sorry for all the questions...

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
adding up number of people present at certain times bamboozled Excel Worksheet Functions 4 September 18th 07 09:02 AM
how to taking a .txt email list that are separated with spaces and sort them in to excel cells [email protected] Excel Worksheet Functions 2 August 3rd 07 12:28 AM
How to send email to a list of people in excel sheet? David Excel Discussion (Misc queries) 1 December 14th 06 12:46 AM
Taking a remainder amount from a column and adding it another colu Help for Jason Excel Discussion (Misc queries) 0 August 2nd 06 05:46 PM
How do I pull a random sample of people from a list in excel? PM Excel Worksheet Functions 6 November 29th 05 04:41 AM


All times are GMT +1. The time now is 09:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"