# Button to pair 4N PW

on
button in BX2

to pick up the pair from BF ( 1 set )

repeat from 3 or more only

as  show here

29084854_4N_F_rigths_.xlsm
Comment
Watch Question

Do more with

EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Older than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
OK, this may take a while.

Commented:
I suppose you want to move a group of numbers in column BF to columns BX and BY.
But can you please explain in more detail how the numbers shall be selected in column BF, and prepared to be written to columns BX and BY.
ACCOUNTING ASSISTANT

Commented:

Thnaks for the fast reponse

in Column BF are the set of numbers
then  need identify the pair repeat
then the most repeat (over 3 times) be show in column BX   and column BY show the times it repeat
Older than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
ACCOUNTING ASSISTANT

Commented:
Martin

Great JOB !

Older than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
I thought you ignored the matches when both numbers (like 6 and 6) were the same. I can change it.
Older than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Is this better?
29084860a.xlsm
ACCOUNTING ASSISTANT

Commented:
Martin

Is an great job  i know is not that easy

but we in the way

here an situation as show here
Older than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Is this correct?

And would you rather see '48' instead of '84'?
ACCOUNTING ASSISTANT

Commented:
Martin

Is this correct?
as  the pic show in ID: 42474536

Not is not good

this the good count
as show here

48      3
44      3

And would you rather see '48' instead of '84'?

this is the order i need
to see always

2 , 4 , 6 , 8, 0
'
then

1 ,3 ,4 ,5,7, 9

that mean 48, is the correct not 84
Older than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Fingers crossed.
29084860b.xlsm
ACCOUNTING ASSISTANT

Commented:
MArtin

very Impressive JOB
almost  done

Older than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
Fixed.
ACCOUNTING ASSISTANT

Commented:
Great Solution

best Expert Ever

Do more with