| Author |
 Topic  |
|
|
zango24
India
Posts |
 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
|
|
|
zango24
India
Posts |
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! |
 |
|
|
snowli
USA
1395 Posts |
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
India
Posts |
Posted - 01/31/2015 : 11:51:02 PM
|
Dear Snow,
Thank you so much.
Cheers,
Zan |
|
|
| |
Topic |
|
|
|
How to select rows in a column with duplicate numb