Duplicate names in one cell column

Hi,

I have a cell that contain several columns among them one text column (e.g., Person names). How can I check that the there is no duplicate names inside this column (If there is a duplicate names just assign duplicateName=true).

Thanks

Answer 1

[Yatin]

Hi,

You can use the " hist " functions and the unique functions to determine if there are any duplicate values in your columns. Below is a sample code snippet:

arr = [5 3 1 5 6];
u = unique(arr);
n = hist(arr, u);
result = arr(n > 1);

Hope this helps.

Answer 2

[Jan]

duplicateName = (numel(unique(C(:, index))) == size(C, 1))

[EDITED: Parenthesis fixed]

[hsi]

Thanks for the reply but I do not understand what is the index in the numel(unique(C(:, index))?

Cell example:

C = { '1st';'2st';'3st';'first';'2st'};

[Jan]

In your question you wrote:

 I have a cell that contain several columns among them one text column

Then index is the index of the column, which contains the text. If C is this column already, use:

numel(unique(C)) == size(C, 1)