LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default how to show whether 3 cells within a row match 3 cells in another

Novice here...

How do I show or highlight, within a single worksheet, rows of cells that
have matching data with other rows in another part of the worksheet.

For example:
the worksheet has about 10,000 rows, and 11 columns.
I want to the formula to look through the entire worksheet and highlight for
me any single row which "matches" any other single row.
Whether or not it matches would be based on whether the data in columns B,
E, and J for that row match.
Column B is a number, Column E is a date, and Column J is another number.

025847 10/27/2008 012
025847 10/27/2008 013
025843 10/27/2008 012
025847 10/27/2008 012
025847 10/27/2008 012

For example, rows 1, 4, and 5 from the above example, I want those to show
up as matches.

Is this feasible?
 
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
Excel: match two cells in one sheet to two cells in another and return a third cells value Spence Excel Worksheet Functions 3 February 13th 11 05:33 AM
Cells won't change font color or show hi-lighted cells in document ROBIN Excel Discussion (Misc queries) 1 March 27th 08 09:39 PM
Match cells with cells on another workbook James1976 Excel Worksheet Functions 1 October 31st 06 05:28 PM
Want to show/hide cells depending on other cells results Marco Excel Discussion (Misc queries) 0 August 15th 06 06:21 PM
Query counting cells in a row that exactly match cells in another Marlsnz Excel Discussion (Misc queries) 1 June 2nd 06 07:08 AM


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