Path: news.mathworks.com!not-for-mail
From: <HIDDEN>
Newsgroups: comp.soft-sys.matlab
Subject: Removing duplicates
Date: Mon, 16 Apr 2012 02:25:07 +0000 (UTC)
Organization: The MathWorks, Inc.
Lines: 25
Message-ID: <jmfvu3$sl3$1@newscl01ah.mathworks.com>
Reply-To: <HIDDEN>
NNTP-Posting-Host: www-01-blr.mathworks.com
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
X-Trace: newscl01ah.mathworks.com 1334543107 29347 172.30.248.46 (16 Apr 2012 02:25:07 GMT)
X-Complaints-To: news@mathworks.com
NNTP-Posting-Date: Mon, 16 Apr 2012 02:25:07 +0000 (UTC)
X-Newsreader: MATLAB Central Newsreader 3438562
Xref: news.mathworks.com comp.soft-sys.matlab:764614

I was wondering if it would be possible to do the following.

I have a set of data in one column with ID numbers:

ID:
22
22
33
33
44
44
55
55
66
66
66
77
77
88
88
88

The first and second row should be the same. However, there are scenarios like with 66 and 88 that the identifier and the data that comes along with it repeats 3x.  I would like to remove the middle duplicate -i am not able to do anything in excel and was wondering if there's any type of checking/verifying in matlab?

thanks.