summary function

[#1]

I noticed the summary function did not category the row correctly when the table is huge this week.

I have one column (e.g. col A) containing very long characters. I try to see how many unique rows per the content of col A. JMP did generate a summary table without any error messages. To my surprise, the sub-table per the summary table still contains some unique rows. Anyone knows why?

[#2]

1. Upper/Lower case mismatches
2. Double spaces between words for some entries and single spaces for other entries
3. Preceding or trailing blanks
4. Non printable characters

[#3]

The discrepancy I observed seems like that the criteria used to define matching row by Table summary function is different from that used by selecting matching rows. is this true? If yes, please elaborate the difference.

[#4]

If you create a new column, baised ono the grouping column in the Summary that is producing the unique rows, and specify the formula
Hex(your column of concern here)
you will be able to compare the exact values for all of the characters in the cells. What you need to do then, is to compare the unique row data with the non unique row and see what the difference is.