simplest is usually the quickest...or I've just got a dumb way of doing
things. I'd create an extra column which equalled the text value of the cells
in question ie ="b"&"E"&"J" which will give you a unique value.
Then click on pivottable and arrange it so your unique value is the first
column and any number is the datatable, it'll group any duplicates for you

ta
DOug

"Swish7" wrote:

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?