duplicate rows
Hi,
I know this is probably an easy one but I can't seem to make it work. I have 6 columns of 3 digit zip codes, some repeat in the same row.
201 401 301 212 311 212
311 412 311 212 212 311
What is the easiest way to find duplicate rows? What I need is to compare row 1 to all rows for duplicates( of the exact row ie. a1-f1) then compare row 2 ,row 3 etc.
I have tried =countifs but I can not make the formula work.....
Can someone please help?
Thank you
Hi
One way to do this, is using Conditional Formatting, to fill with color the cells in your range that containing the same values.
Formula for this, is: =COUNTIF($A1:$F1;A1)>1 And pull down as much as you need.
Hope to helps you.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
try this in G1:
Confirmed with Ctrl-shift-enter.
Please Login or Register to view this content.
Rows with duplicated data (A:F) with others will be marked with "duplicated".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks