Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 25
Default HIGHLIGHTING DULPICATES WITH TWO COLUMNS & DELETING DUPLICATE

Sirs,
I request formula if Col-A & B Having Duplicate (NOT ONE COLUMN), that cells
to be highlighted. (AS PER BELOW SAMPLE - ROW 1 & 5 OF COL-A & B TO BE
HIGHLIGHT) And for another application, i want to delete the duplicate cells
or rows.(CELL - A5 TO BE DELETE) PLEASE FIND THE SAMPLE DATA
COL-A COL-B
AC-A3654-023-02 2
AC-A3654-023-02 4
AC-A3655-024-03 1
AC-A3654-023-03 2
AC-A3654-023-02 2
Request you to help on this & save my time.

-PERANISH
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
Highlighting duplicate cells in a column Nanapat Excel Discussion (Misc queries) 2 July 29th 07 01:59 AM
Highlighting duplicate entries Seb Warmoth Excel Worksheet Functions 2 March 12th 07 12:40 PM
deleting duplicate cells in several columns bullseye Excel Worksheet Functions 4 December 5th 06 04:49 PM
Highlighting Duplicate Values Rothman Excel Worksheet Functions 2 August 30th 06 02:46 PM
highlighting duplicate values Alice Excel Worksheet Functions 2 February 10th 06 06:39 AM


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