Results 1 to 4 of 4

find duplicate cells in rows across multiple column

Threaded View

  1. 01-11-2023, 09:30 AM #1
    pannam
    pannam is offline
    Registered User
    Join Date
    01-27-2014
    Location
    kathmandu
    MS-Off Ver
    Microsoft Excel for Mac version 16.68, Office LTSC
    Posts
    33

    find duplicate cells in rows across multiple column

    I have a lot data with duplicate values in a row, I want to check the duplicates and highlight them with different colors. I can do that easily for one row. choose conditional formatting ->Highlight cell rules -> duplicate values ...
    But then i have apply this formatting across multiple columns, i have to do it one by one. Any shortcuts or formula ?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. vba code to find the last duplicate entry in a column and delete other rows
    By stefanp in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-18-2019, 06:37 PM
  2. Dictionary or other object to find out duplicate rows across column values
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-27-2019, 01:07 PM
  3. [SOLVED] Excel VBA to find Duplicate Entries with multiple column combination and Display Rows Numb
    By mchilapur in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-19-2018, 05:36 AM
  4. Find duplicate rows involving 2 columns with column 2 criteria
    By drgkt in forum Excel General
    Replies: 5
    Last Post: 12-18-2015, 10:21 AM
  5. [SOLVED] Find duplicate rows based on two column values and group
    By kevivu in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-30-2015, 12:10 AM
  6. [SOLVED] Macro to find duplicate values in a column and add the corresponding rows
    By hoss88 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-25-2013, 05:40 AM
  7. Find duplicate text in cells in column, then give names of cells containing duplicate text
    By spelunkerforlife in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2013, 10:13 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1