#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 25
Default Excel question

Hello. I am fairly new at Excel. I have made a spreadsheet with 500 entries
(4 fields each). I see there are some duplicates. Is these an easy way to
find duplicates, or remove duplicates?

Thanks
Molly
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,091
Default Excel question

You don't state what version of Excel you're using. That is very helpful
here. If you are using Excel 2007, then Data/Data Tools/Remove Duplicates
may help you.
I suggest that no matter what you do, you save a copy of your workbook just
in case.

Tyro

"Molly" wrote in message
...
Hello. I am fairly new at Excel. I have made a spreadsheet with 500
entries
(4 fields each). I see there are some duplicates. Is these an easy way
to
find duplicates, or remove duplicates?

Thanks
Molly



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 25
Default Excel question

Thanks Tyro! I am using Excel 2007.

Much appreciated.

Molly

"Tyro" wrote:

You don't state what version of Excel you're using. That is very helpful
here. If you are using Excel 2007, then Data/Data Tools/Remove Duplicates
may help you.
I suggest that no matter what you do, you save a copy of your workbook just
in case.

Tyro

"Molly" wrote in message
...
Hello. I am fairly new at Excel. I have made a spreadsheet with 500
entries
(4 fields each). I see there are some duplicates. Is these an easy way
to
find duplicates, or remove duplicates?

Thanks
Molly




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
excel question [email protected] Excel Worksheet Functions 1 March 28th 07 11:48 PM
Newbie Question - Subtraction Formula Question [email protected] Excel Discussion (Misc queries) 3 May 5th 06 05:50 PM
The question is an excel question that I need to figure out howto do in excel. Terry Excel Worksheet Functions 3 January 23rd 06 06:22 PM
The above is an excel question Terry Excel Worksheet Functions 0 January 23rd 06 01:42 PM
Statistical Excel Function Question within Excel 2000... Drew H Excel Worksheet Functions 3 October 31st 04 06:55 PM


All times are GMT +1. The time now is 11:57 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"