Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
Cells won't change font color or show hi-lighted cells in document | Excel Discussion (Misc queries) | |||
Match cells with cells on another workbook | Excel Worksheet Functions | |||
Want to show/hide cells depending on other cells results | Excel Discussion (Misc queries) | |||
Query counting cells in a row that exactly match cells in another | Excel Discussion (Misc queries) |