A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

removing duplicate entries, formatting tables from outside programs



 
 
Thread Tools Display Modes
  #1  
Old August 1st, 2004, 11:43 AM
aston75
external usenet poster
 
Posts: n/a
Default 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  
Old August 1st, 2004, 02:25 PM
Shauna Kelly
external usenet poster
 
Posts: n/a
Default 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  
Old August 1st, 2004, 02:57 PM
Doug Robbins
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 06:42 PM.


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