All formations of suits of each two groups digit Are even / odd 0.2,4,6,8 1,3,5,7,9

piter

Active Member
Joined
Jul 22, 2011
Messages
316
Office Version
  1. 2016
Platform
  1. Windows
All formations of suits of each two groups digit
Are even / odd
0.2,4,6,8
1,3,5,7,9
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
I think we need more details.

Where is the list of numbers coming from?
Are you just trying to split them up into two groups, one group of odd numbers and one group of even numbers?
What are you doing with these groups after your split them?
 
Upvote 0
008= corret
117=corret
181= error It's wrong because it's even and odd.
The correct one is only pairs and only odd
 
Last edited:
Upvote 0
Upvote 0
Todos os duplos: 270 combinações retas
001, 010, 100, 002, 020, 200, 003, 030, 300, 004, 040, 400, 005, 050, 500, 006, 060, 600, 007, 070, 700, 008, 080, 800, 009, 090, 900, 011, 101, 110, 022, 202, 220, 033, 303, 330, 044, 404, 440, 055, 505, 550, 066, 606, 660, 077, 707, 770, 088, 808, 880, 099, 909, 990, 112, 121, 211, 113, 131, 311, 114, 141, 411, 115, 151, 511, 116, 161, 611, 117, 171, 711, 118, 181, 811, 119, 191, 911, 122, 212, 221, 133, 313, 331, 144, 414, 441, 155, 515, 551, 166, 616, 661, 177, 717, 771, 188, 818, 881, 199, 919, 991, 223, 232, 322, 224, 242, 422, 225, 252, 522, 226, 262, 622, 227, 272, 722, 228, 282, 822, 229, 292, 922, 233, 323, 332, 244, 424, 442, 255, 525, 552, 266, 626, 662, 277, 727, 772, 288, 828, 882, 299, 929, 992, 334, 343, 433, 335, 353, 533, 336, 363, 633, 337, 373, 733, 338, 383, 833, 339, 393, 933, 344, 434, 443, 355, 535, 553, 366, 636, 663, 377,737, 773, 388, 838, 883, 399, 939, 993, 445, 454, 544, 446, 464, 644, 447, 474, 744, 448, 484, 844, 449, 494, 944, 455, 545, 554, 466, 646, 664, 477, 747, 774, 488, 848, 884, 499, 949, 994, 556, 565, 655, 557, 575, 755, 558, 585, 855, 559, 595, 955, 566, 656, 665, 577, 757, 775, 588, 858, 885, 599, 959, 995, 667, 676, 766, 668, 686, 866, 669, 696, 966, 677, 767, 776, 688, 868, 886, 699, 969, 996, 778, 787, 877, 779, 797, 977, 788, 878, 887, 799, 979, 997, 889, 898, 988, 899, 989, 998688, 868, 886, 699, 969, 996, 778, 787, 877, 779, 797, 977, 788, 878, 887, 799, 979, 997, 889, 898, 988, 899, 989, 998688, 868, 886, 699, 969, 996, 778, 787, 877, 779, 797, 977, 788, 878, 887, 799, 979, 997, 889, 898, 988, 899, 989, 998466, 646, 664, 477, 747, 774, 488, 848, 884, 499, 949, 994, 556, 565, 655, 557, 575, 755, 558, 585, 855, 559, 595, 955, 566, 656, 665, 577, 757, 775, 588, 858, 885, 599, 959, 995, 667, 676, 766, 668, 686, 866, 669, 696, 966, 677, 767, 776, 688, 868, 886, 699, 969, 996, 778, 787, 877, 779, 797, 977, 788, 878, 887, 799, 979, 997, 889, 898, 988, 899, 989, 998688, 868, 886, 699, 969, 996, 778, 787, 877, 779, 797, 977, 788, 878, 887, 799, 979, 997, 889, 898, 988, 899, 989, 998688, 868, 886, 699, 969, 996, 778 787 877 779 797 977 788 878 887 799 979 997 889 898 988 899 989 998466, 646, 664, 477, 747, 774, 488, 848, 884, 499, 949, 994, 556, 565, 655, 557, 575, 755, 558, 585, 855, 559, 595, 955, 566, 656, 665, 577, 757, 775, 588, 858, 885, 599, 959, 995, 667, 676, 766, 668, 686, 866, 669, 696, 966, 677, 767, 776, 688, 868, 886, 699, 969, 996, 778, 787, 877, 779, 797, 977, 788, 878, 887, 799, 979, 997, 889, 898, 988, 899, 989, 998688, 868, 886, 699, 969, 996, 778, 787, 877, 779, 797, 977, 788, 878, 887, 799, 979, 997, 889, 898, 988, 899, 989, 998688, 868, 886, 699, 969, 996, 778 787 877 779 797 977 788 878 887 799 979 997 889 898 988 899 989 998969, 996, 778, 787, 877, 779, 797, 977, 788, 878, 887, 799, 979, 997, 889, 898, 988, 899, 989, 998688, 868, 886, 699, 969, 996, 778, 787, 877, 779, 797, 977, 788, 878, 887, 799, 979, 997, 889, 898, 988, 899, 989, 998688, 868, 886, 699, 969, 996, 778, 787, 877, 779, 797, 977, 788, 878, 887, 799, 979, 997, 889, 898, 988, 899, 989, 998969, 996, 778, 787, 877, 779, 797, 977, 788, 878, 887, 799, 979, 997, 889, 898, 988, 899, 989, 998688, 868, 886, 699, 969, 996, 778, 787, 877, 779, 797, 977, 788, 878, 887, 799, 979, 997, 889, 898, 988, 899, 989, 998688, 868, 886, 699, 969, 996, 778, 787, 877, 779, 797, 977, 788, 878, 887, 799, 979, 997, 889, 898, 988, 899, 989, 998
 
Upvote 0
Joe nesta mesa tem apenas pares e é estranho e mesclado
Sua tarefa para separar os mistos.
 
Upvote 0
Você precisa filtrar as 3 picaretas misturadas
Onde é o número ímpar e par
 
Upvote 0
Since you seem to want to continue this in a different language, I am moving it to the "Questions in Other Languages" forum, and we can see if someone who speaks your language can help.
To me, the big problem is that you have not defined what you mean by "mixed". You have not done a very good job of explaining your problem, which is why you had not gotten any replies initially.
Like I said, if you post some complete example of what your data looks like, and what you expected results should look like, I think that will go a long way in helping to understand exactly what it is you are trying to do.
 
Upvote 0
Misturado é dígito e dígito ímpares
O treinamento não deve ser uniforme e estranho
 
Upvote 0

Forum statistics

Threads
1,223,894
Messages
6,175,254
Members
452,624
Latest member
gregg777

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top