Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have 12 columns each with various amounts of data in them. I am trying to
see if there are any duplicates on the sheet at all so column B might have data that is also in column E, and column A might have data that is also in column L. I need a way to see which items are duplicates and highlight them possibly. I tried the =if(countif(A:A,B1)0,"Dup","") function listed in this forum, but it is not very efficient for the amount of data I have, can anyone help? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Try this:
http://www.cpearson.com/excel/duplic...tingDuplicates Maybe that will work better for you. ************ Hope it helps! Anne Troy www.OfficeArticles.com Check out the NEWsgroup stats! Check out: www.ExcelUserConference.com "WBTKbeezy" wrote in message ... I have 12 columns each with various amounts of data in them. I am trying to see if there are any duplicates on the sheet at all so column B might have data that is also in column E, and column A might have data that is also in column L. I need a way to see which items are duplicates and highlight them possibly. I tried the =if(countif(A:A,B1)0,"Dup","") function listed in this forum, but it is not very efficient for the amount of data I have, can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
data duplication check ? | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |