If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
removing duplicate entries, formatting tables from outside programs
Im posting this in word and excel forums, because I use
both of these programs in this task. Id like to reduce a task which currently takes a while of 'stuffing around' to something quick and easy. I use an internal work program and work in an office where about 150 people come in each day and we need to put down a written result (unavoidable! ) for each person. Basically what spits out from the system is a list of names which can be opened by excel. After organising into alphabetical order, some people appear once (Which is what i want), some twice, 10 times and even 50. What I want to do is to be able to reduce the list to one name/entry for each person, so that I can get a list of people each day, without the need for tedious deleting of names and rows. Does anyone know if there is a function in excel or word to do this (thus deleting duplicate names)? Basically each name then goes into a result sheet, I currently paste from excel into word, (where results are written in, in pen) to see what has happened with this people on the day. I'd like to be able to get this list and put it into word as quickly as possible. It's basically a table with number of the person on the left, the persons name, then a space for a result, with a heading with date and things on the top. Can anyone help with an easier way to organize all this? Previously, people would physically type each name out from the lists from our internal program, but I know there would be an easier way. Thanks for any help. cheers |
#2
|
|||
|
|||
removing duplicate entries, formatting tables from outside programs
Hi aston75
Excel has several tools that should be able to help you. If you have posted this question to an Excel newsgroup, then I'm sure you'll find appropriate solutions there. Hope this helps. Shauna Kelly. Microsoft MVP. http://www.shaunakelly.com/word "aston75" wrote in message ... Im posting this in word and excel forums, because I use both of these programs in this task. Id like to reduce a task which currently takes a while of 'stuffing around' to something quick and easy. I use an internal work program and work in an office where about 150 people come in each day and we need to put down a written result (unavoidable! ) for each person. Basically what spits out from the system is a list of names which can be opened by excel. After organising into alphabetical order, some people appear once (Which is what i want), some twice, 10 times and even 50. What I want to do is to be able to reduce the list to one name/entry for each person, so that I can get a list of people each day, without the need for tedious deleting of names and rows. Does anyone know if there is a function in excel or word to do this (thus deleting duplicate names)? Basically each name then goes into a result sheet, I currently paste from excel into word, (where results are written in, in pen) to see what has happened with this people on the day. I'd like to be able to get this list and put it into word as quickly as possible. It's basically a table with number of the person on the left, the persons name, then a space for a result, with a heading with date and things on the top. Can anyone help with an easier way to organize all this? Previously, people would physically type each name out from the lists from our internal program, but I know there would be an easier way. Thanks for any help. cheers |
#3
|
|||
|
|||
removing duplicate entries, formatting tables from outside programs
There's a method for doing this given in the article "Finding and replacing
characters using wildcards" at: http://word.mvps.org/FAQs/General/UsingWildcards.htm -- Please respond to the Newsgroup for the benefit of others who may be interested. Questions sent directly to me will only be answered on a paid consulting basis. Hope this helps, Doug Robbins - Word MVP "aston75" wrote in message ... Im posting this in word and excel forums, because I use both of these programs in this task. Id like to reduce a task which currently takes a while of 'stuffing around' to something quick and easy. I use an internal work program and work in an office where about 150 people come in each day and we need to put down a written result (unavoidable! ) for each person. Basically what spits out from the system is a list of names which can be opened by excel. After organising into alphabetical order, some people appear once (Which is what i want), some twice, 10 times and even 50. What I want to do is to be able to reduce the list to one name/entry for each person, so that I can get a list of people each day, without the need for tedious deleting of names and rows. Does anyone know if there is a function in excel or word to do this (thus deleting duplicate names)? Basically each name then goes into a result sheet, I currently paste from excel into word, (where results are written in, in pen) to see what has happened with this people on the day. I'd like to be able to get this list and put it into word as quickly as possible. It's basically a table with number of the person on the left, the persons name, then a space for a result, with a heading with date and things on the top. Can anyone help with an easier way to organize all this? Previously, people would physically type each name out from the lists from our internal program, but I know there would be an easier way. Thanks for any help. cheers |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Office XP | Ed Lester | Setup, Installing & Configuration | 1 | May 27th, 2004 09:30 AM |
Duplicate Entries | Laurynne | Worksheet Functions | 3 | September 26th, 2003 07:05 PM |
remove duplicate entries | Jeff Schnakenberg | Worksheet Functions | 1 | September 18th, 2003 09:16 PM |