Welcome Guest
Log In | Register )
You last visited December 10, 2016, 7:35 am
All times shown are
Eastern Time (GMT-5:00)

to get rid of identical line

Topic closed. 11 replies. Last post 8 months ago by AllenB.

Page 1 of 1
51
PrintE-mailLink
Avatar
New Member

France
Member #137064
December 26, 2012
4 Posts
Offline
Posted: April 16, 2016, 4:15 pm - IP Logged

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
10 19 29 30 43
10 19 29 31 32

All lines identical I want to get rid of them. Is there any formula. I use openoffice Calc. any help welcome.

    winsumloosesum's avatar - Lottery-060.jpg
    Pennsylvania
    United States
    Member #2218
    September 1, 2003
    5387 Posts
    Online
    Posted: April 16, 2016, 4:52 pm - IP Logged

    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.

      Avatar
      New Member

      France
      Member #137064
      December 26, 2012
      4 Posts
      Offline
      Posted: April 16, 2016, 5:30 pm - IP Logged

      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

        winsumloosesum's avatar - Lottery-060.jpg
        Pennsylvania
        United States
        Member #2218
        September 1, 2003
        5387 Posts
        Online
        Posted: April 16, 2016, 5:44 pm - IP Logged

        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

          mmx1's avatar - 8ball

          Canada
          Member #90040
          April 20, 2010
          473 Posts
          Offline
          Posted: April 16, 2016, 6:54 pm - IP Logged

          You can remove duplicate lines HERE as well.

            Avatar
            New Member

            France
            Member #137064
            December 26, 2012
            4 Posts
            Offline
            Posted: April 17, 2016, 3:08 am - IP Logged

            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 29 31 38 

            In exit I should have:

            10 19 27 31 35
            10 19 27 31 38
            10 19 27 32 38
            10 19 27 45 47
            10 19 29 31 32
            10 19 27 31 35
            10 19 29 31 38

            I hope I made my self understood the lines like

            10 19 27 32 41

            10 19 27 32 41 are gone both

            Thanks in advance

              mmx1's avatar - 8ball

              Canada
              Member #90040
              April 20, 2010
              473 Posts
              Offline
              Posted: April 17, 2016, 10:17 am - IP Logged

              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 29 31 38 

              In exit I should have:

              10 19 27 31 35
              10 19 27 31 38
              10 19 27 32 38
              10 19 27 45 47
              10 19 29 31 32
              10 19 27 31 35
              10 19 29 31 38

              I hope I made my self understood the lines like

              10 19 27 32 41

              10 19 27 32 41 are gone both

              Thanks in advance

              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?

                Avatar

                United States
                Member #132100
                August 26, 2012
                1078 Posts
                Offline
                Posted: April 17, 2016, 11:22 am - IP Logged

                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?

                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.

                  Avatar
                  New Member

                  France
                  Member #137064
                  December 26, 2012
                  4 Posts
                  Offline
                  Posted: April 17, 2016, 12:35 pm - IP Logged

                  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 to 5 correctly like 2-2 1-1. sometimes they repeat. from 5000+ lines you end up with 300 to 400 lines to play. With deletting the doubles you finish with 100 to 200. This what I see in a real. I am not a gambler. I play about $4 a week to be in safe side. I am a retire, and like to train my brain not to be idle. English is not my mother tongue language. I hope what I am writing would be understood in a positive way. Thousand thinks for your help

                    RL-RANDOMLOGIC's avatar - usafce

                    United States
                    Member #59354
                    March 13, 2008
                    3985 Posts
                    Offline
                    Posted: April 24, 2016, 6:40 am - IP Logged

                    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

                    Working on my Ph.D.  "University of hard Knocks"

                    I will consider the opinion that my winnings are a product of chance if you are willing to consider

                    they are not.  Many great discoveries come while searching for something else

                    USAF https://en.wikipedia.org/wiki/Prime_Base_Engineer_Emergency_Force

                      US Flag Trump / 2016 & 2020  

                      Avatar
                      Lincoln, California
                      United States
                      Member #167130
                      June 27, 2015
                      256 Posts
                      Offline
                      Posted: April 24, 2016, 11:01 am - IP Logged

                      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
                      10 19 29 30 43
                      10 19 29 31 32

                      All lines identical I want to get rid of them. Is there any formula. I use openoffice Calc. any help welcome.

                      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

                      2

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

                      10 19 27 44 45

                      2

                      =COUNTIF($A$1:A9,A8)

                      10 19 27 44 45

                      2

                      =COUNTIF($A$1:A10,A9)

                      10 19 27 44 47

                      2

                      =COUNTIF($A$1:A11,A10)

                      10 19 27 44 47

                      2

                      =COUNTIF($A$1:A12,A11)

                      10 19 27 45 47

                      1

                      =COUNTIF($A$1:A13,A12)

                      10 19 27 46 48

                      2

                      =COUNTIF($A$1:A14,A13)

                      10 19 27 46 48

                      2

                      =COUNTIF($A$1:A15,A14)

                      10 19 29 30 43

                      2

                      =COUNTIF($A$1:A16,A15)

                      10 19 29 30 43

                      2

                      =COUNTIF($A$1:A17,A16)

                      10 19 29 31 32

                      1

                      =COUNTIF($A$1:A18,A17)