| T O P I C R E V I E W |
| zango24 |
Posted - 01/31/2015 : 1:11:16 PM
Origin Ver. 8 and Service Release (Select Help-->About Origin):
Operating System:win 7
Hello friends,
I have a column with several numbers in series. Just like 1,2,3,4,4,4,5,5,6,7,8,8,8,8,8,8,9,10,11,11,12,13,14,15,16,17,18,19,20,20,and so on. As you see many numbers just duplicate at random rows.
So I would like to highlight only those numbers which are duplicate of each other. For example number 4,5,8,11 etc....
any small script would be very helpful or else please suggest other simple method.....
Cheers,
zan
|
| 3 L A T E S T R E P L I E S (Newest First) |
| zango24 |
Posted - 01/31/2015 : 11:51:02 PM
Dear Snow,
Thank you so much.
Cheers,
Zan |
| snowli |
Posted - 01/31/2015 : 2:28:20 PM
1. Choose Worksheet: Worksheet Query.
2. Suppose A is the column, move col(A) from left panel to the right. It should be given alias name A.
3. Enter diff(A)=0 in If box
Or no need to do step 2, just enter diff(col(A))=0 in If box
4. Click Test - Select if true
Note: diff(col(A)) gives difference from two adjacent rows in col(A), so it's same as col(A)[i+1]-col(A)[i]
Thanks, Snow
|
| zango24 |
Posted - 01/31/2015 : 1:17:06 PM
I forgot to mention that I just need to select these rows. I don't want to delete rows with duplicate numbers! |
|
|
