to get rid of identical line

Reply #11

AllenB — Sun, 24 Apr 2016 15:01:50 GMT

You can do this in Excel as follows: The first column is your list, The second column is the equation in column 2. All you have to do is filter column 2 and select the value 1 to eliminate the duplicates

10 19 27 31 38

1

=COUNTIF($A$1:A3,A2)

10 19 27 32 38

1

=COUNTIF($A$1:A4,A3)

10 19 27 32 41

2

=COUNTIF($A$1:A5,A4)

10 19 27 32 41

2

=COUNTIF($A$1:A6,A5)

10 19 27 40 41

2

=COUNTIF($A$1:A7,A6)

10 19 27 40 41

Reply #10

RL-RANDOMLOGIC — Sun, 24 Apr 2016 10:40:51 GMT

Kass59

When doing a back-test use the B-Test option. This sets the program so that it skips the

first line in the database and starts on the second. The most current values displayed are

from the last 2 games. The B-test button causes the program to start collecting data as it

was before the last update. Use the Run option for live play and B-Test if doing a after the

fact setup.

RL

Reply #9

kass59 — Sun, 17 Apr 2016 16:35:09 GMT

Thanks mmx1

I use t-lex. The set I got from t-lex, I put them on the t-lex shreder and I noticed that run and test doesn't give the same result and one give the correct line I mean 5 numbers the correct line is never on the double lines. I didn't won nothing yet. Just playing to learn. The best strategie is to come and find the correct lexie. It didn't happen yet to me but I am a patient grown up boy. The shdreder is a real powerfull tool when used in the right way. I mean to set the first 3... [ More ]

Reply #8

MonEl — Sun, 17 Apr 2016 15:22:21 GMT

Good!

It was very hard to find, but I also found a way to do that.

But let him or she use your online tools instead, what I found is not exactly 100% what he or she wants, it needs a little work on the results to get them 100% right, but just a little work, anyhow, this time I will keep to myself what I found.

Reply #7

mmx1 — Sun, 17 Apr 2016 14:17:51 GMT

Now you have one more button for unique lines HERE .

We can help you out, but you could also share your strategy with us.

How do you get your combinations?

Why do you need only unique lines

Reply #6

kass59 — Sun, 17 Apr 2016 07:08:04 GMT

Thanks mmx1 for your tools and winsumloosesum for your help. I wanted something else something that get rid of the line and his duplicate as follows:

In entry I had

10 19 27 31 35

10 19 27 31 38

10 19 27 32 38

10 19 27 32 41

10 19 27 32 41

10 19 27 40 41

10 19 27 40 41

10 19 27 44 45

10 19 27 44 45

10 19 27 44 47

10 19 27 44 47

10 19 27 45 47

10 19 27 46 48

10 19 27 46 48

10 19 29 30 43

10 19 29 30 43

10 19 29 31 32

10 19 29 31 35

10 19... [ More ]

Reply #5

MonEl — Sun, 17 Apr 2016 03:06:49 GMT

http://textmechanic.com/text-tools/basic-text-tools/remove-duplicate-lines/

http://www.textfixer.com/tools/remove-duplicate-lines.php

http://www.dedupelist.com/

http://www.miniwebtool.com/remove-duplicate-lines/

http://www.esqsoft.com/tools/dedupe-list.htm

http://www.techmynd.com/tools/remove-duplicate-lines.php

Reply #4

mmx1 — Sat, 16 Apr 2016 22:54:08 GMT

You can remove duplicate lines HERE as well.

Reply #3

winsumloosesum — Sat, 16 Apr 2016 21:44:39 GMT

Actually it is an OpenOffice Calc program but onedrive tries to open the file as if it was Excel.

I zipped the program in a folder:

Download link:

https://onedrive.live.com/redir?resid=2B334DB02ABFE027!334 authkey=!AFiltbqFPgIEFcM ithint=file%2czip

Reply #2

kass59 — Sat, 16 Apr 2016 21:30:09 GMT

Thanks winsumloosesum for your swift response, I got only OppenOffice Calc no Microsoft Exel. Sorry again for your hard work and maybe someone else if there is will come up with a solution. Thanks again

Reply #1

winsumloosesum — Sat, 16 Apr 2016 20:52:56 GMT

https://onedrive.live.com/redir?resid=2B334DB02ABFE027!332 authkey=!AM6zQtDlzAHZlHg ithint=file%2cods

Just filter row H and select value 0 (zero) this will filter all the repeat sets.

to get rid of identical line

kass59 — Sat, 16 Apr 2016 20:15:39 GMT

Hi If I could have any help I merge 2 files in on file with openoffice Calc I sort them in ascending order. I got a lot of identical lines. I wanted to wipe out all identical lines.

for example

10 19 27 31 35

10 19 27 31 38

10 19 27 32 38

10 19 27 32 41

10 19 27 32 41

10 19 27 40 41

10 19 27 40 41

10 19 27 44 45

10 19 27 44 45

10 19 27 44 47

10 19 27 44 47

10 19 27 45 47

10 19 27 46 48

10 19 27 46 48

10 19 29 30 43