Sorry, but it IS working as designed. In your posting, rows 2 and 5 contain identical data in all fields. Therefore the "records" are duplicates and one is omitted from the output listing starting at cell G4. The date field in row 4 is different from rows 2 and 5 and therefore that record is NOT a duplicate.

Well, maybe it is working "as designed" but then calling this "How to find duplicates in Excel" is an overstatement.

When I read "finding duplicates in Excel" then I assume that's exactly what this function does - I select a list range (which in my case was just a 3x5 matrix of ten-digit numbers and I expected this function to find the duplicate numbers in those 15 cells and only display any duplicate or triplicate numbers once in the results.

But that isn't what the function does - it assumes that each cell in a row is part of the same record.

So OK, misunderstanding on what the function actually does.

But what I then don't understand - after I made one of the rows of five entries identical to a row above - why would the function not identify that row as a duplicate record?

I'll have to play with this a bit more in the morning.

I had another interesting Excel experience earlier tonight -

I have a single column of data that follows a pattern where the data is displayed in groups of three, say first name, last name, telephone number.

I want to rearrange that so that first name, last name and telephone number are shown in one row rather than below each other, so a single column of 99 entries would become three columns of 33 entries each.

This is something I run into all the time and I would have thought that Excel provides a function to do that transformation. However, it's not a transformation I can find in Excel.

Rather than use an elaborate formula to do this conversion (which is what you find when searching for this on google), I ended up pasting the single column of data into MSWord, then use the MSWord feature "text to table" which does this transformation nicely and then paste the whole thing back into Excel.