Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlight all repeat datas in a worksheet
Hi All,
I have a worksheet with about 400 rows and 20 columns of datas. How can I check to ensure that there are no repeat datas in the worksheet? Your help will be appreacited. Thanks. R vcff |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlight all repeat datas in a worksheet
following link should help
http://www.cpearson.com/excel/Duplicates.aspx "vcff" wrote in message ... Hi All, I have a worksheet with about 400 rows and 20 columns of datas. How can I check to ensure that there are no repeat datas in the worksheet? Your help will be appreacited. Thanks. R vcff |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlight all repeat datas in a worksheet
It's only for single column or row.
What I need is to check the whole worksheet for duplicate data. Is there any way to do it? Tnks "Gaurav" wrote: following link should help http://www.cpearson.com/excel/Duplicates.aspx "vcff" wrote in message ... Hi All, I have a worksheet with about 400 rows and 20 columns of datas. How can I check to ensure that there are no repeat datas in the worksheet? Your help will be appreacited. Thanks. R vcff |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlight all repeat datas in a worksheet
It's an enormous task in Excel prior to 2007. You can create a copy of your
data and then try to use the Remove Duplicates command in 2007. In a quick test it worked with around 60 columns, so it may work on 200 columns, too. If you have MS Access you could import the data to Access, then set the primary key to be all the columns. If there is any row that duplicates any other, Access will refuse to create the index, though that wouldn't, by itself, identify the duplicated data. "vcff" wrote: It's only for single column or row. What I need is to check the whole worksheet for duplicate data. Is there any way to do it? Tnks "Gaurav" wrote: following link should help http://www.cpearson.com/excel/Duplicates.aspx "vcff" wrote in message ... Hi All, I have a worksheet with about 400 rows and 20 columns of datas. How can I check to ensure that there are no repeat datas in the worksheet? Your help will be appreacited. Thanks. R vcff |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlight all repeat datas in a worksheet
OK will give a try.
Tnks for the reply. vcff "Duke Carey" wrote: It's an enormous task in Excel prior to 2007. You can create a copy of your data and then try to use the Remove Duplicates command in 2007. In a quick test it worked with around 60 columns, so it may work on 200 columns, too. If you have MS Access you could import the data to Access, then set the primary key to be all the columns. If there is any row that duplicates any other, Access will refuse to create the index, though that wouldn't, by itself, identify the duplicated data. "vcff" wrote: It's only for single column or row. What I need is to check the whole worksheet for duplicate data. Is there any way to do it? Tnks "Gaurav" wrote: following link should help http://www.cpearson.com/excel/Duplicates.aspx "vcff" wrote in message ... Hi All, I have a worksheet with about 400 rows and 20 columns of datas. How can I check to ensure that there are no repeat datas in the worksheet? Your help will be appreacited. Thanks. R vcff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Repeat title to top of each worksheet | Excel Worksheet Functions | |||
Get Macro to Repeat on Each Worksheet | Excel Discussion (Misc queries) | |||
Highlight repeat entries | Excel Discussion (Misc queries) | |||
Possible? If total in a worksheet 0, highlight worksheet tab? | Excel Worksheet Functions | |||
How can I repeat the copying of a worksheet? | Excel Discussion (Misc queries) |