Hello everyone !
I need to find a combination of 3 numbers frequently appears.
Thank you !
Hello everyone !
I need to find a combination of 3 numbers frequently appears.
Thank you !
Hi,
You'll need to explain a little more. Confirm which cells are original data, which are the results and how you have calculated the results.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi Richard,
The data are in rows, each row has six numbers, the combination of three numbers, not necessarily linked to each other in the ranks of the data, the solution is possible in one cell or three cells.
Thank you!
Sorry but I still have no idea as to how you choose the numbers you want for the results.
We're not psychic - least not all the time and you need to explain your thought process when you do this manually. Often we can imply how you've arrived at results if it's reasonably obvious but with this I have no idea at the moment. You need to help us to help you.
Hi Richard,
The data are random at the moment, since I have still the desired formula, then I found these
two solutions without formula
I did not think the question is so complicated !
Find 3 trio of numbers that appears most, in six columns .
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks