Main Forum > General Computer Support

How do you find all the draws with numbers?

<< < (2/3) > >>

Boggin:
Before the UK's national lottery was increased from £1.00 a line to £2.00 a line, I used to select 10 random numbers and split them into two groups of five.

I then used the first group of 5 and one each of the other group and then used the second group with one each of the first group to give me 10 lines of six numbers.

I was fortunate on one of the draws to have 4 numbers correct which paid me about £400.00.

Those duplicated numbers produced 5 lines of 4 correct.

This is why I don't think you should bother trying to find a method of weeding out those duplicated numbers.

Angelika:
ok, let's not talk about the lottery anymore, forget about it.
I don't want to remove duplicates, I just want to find similar numbers that repeat, I understand that even the best forum experts can't answer. They have no idea how to find it. I didn't know that 20 numbers is the biggest, most complicated thing in the world.
Of course this is possible, but how do you use cells?
Compare cells, the search operation should take one second (yes, extremely fast in EmEditor), but where is the compare cells option.
1 second and you have the result, I just don't know how to use "cell" Emeditor

see: https://www.youtube.com/watch?v=ZQahhj9tBkM

Boggin:
From the video I couldn't see how you could do what you want.

You can compare cells using a spreadsheet but it compares one column against another, which is probably not what you want, but perhaps you could work your numbers into columns.

This is how to do it in a Google Sheet - https://www.techrepublic.com/article/how-to-find-duplicates-in-google-sheets/

This is the download for a Google Sheet to see if it helps - https://www.google.co.uk/sheets/about/

Angelika:
I don't understand the sheets - I have no idea what these commands are about ...
I am not a programmer-mathematician, nor do I know what these formulas mean ...
Even if this is explained by some short examples, I still don't know what's going on ...
I tried to do it, but there is always no expected result, even in 1%.

Boggin:
It's over 25yrs since I did any work on spreadsheets and what I learned then is mostly forgotten.

Because of my age, my brain isn't as agile as it once was so I am unable to help you with those either.

Perhaps you may know someone who can.

Navigation

[0] Message Index

[#] Next page

[*] Previous page