S
Swish7
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?
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?