LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default Finding Duplicates in Multiple Columns

I have a spreadsheet with many 5 columns and 3161 rows of data. I want to
find the duplicates rows that have the same data in coumn B and column C and
column F. The other columns can be different, but if there are rows that have
the same exact data in columns B,C, and F, I want to idenify those
duplicates. Any help is appreciated.
 
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
Find Duplicates Rows Based Own Multiple Columns Cue Excel Discussion (Misc queries) 2 June 20th 08 11:43 PM
Finding duplicates in Multiple Columns JCS Excel Discussion (Misc queries) 16 May 13th 08 02:02 PM
Finding & Replacing a list of Data in Multiple Columns Me Excel Worksheet Functions 1 May 5th 08 10:21 AM
Finding duplicates based on 2 columns [email protected] Excel Worksheet Functions 5 March 27th 07 10:31 PM
Finding common data in multiple columns and rows in Excel sparham Excel Worksheet Functions 3 February 12th 05 04:11 AM


All times are GMT +1. The time now is 08:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"