MID Pair 4N by set

count  the pair in MID

then show in column EO and the count in column  EP

as show here

1111cccc.PNG

Here the file
29085934_4N_tri_together_ok_.xlsm
ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?
 
Martin LissOlder than dirtCommented:
Adriana, please let me know if you see this because something very strange is going on. I've attached this workbook again, which is now the 3rd time.
29085944b.xlsm
1
 
Martin LissOlder than dirtCommented:
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

 is not this way

aaaaaa.PNG
This is the correct way
like this

bbbbbbbbb11111.PNG
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
sorry i did not show the correct way

my mistake
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
I should say count the  repeat  PAIRs  in MID
0
 
Martin LissOlder than dirtCommented:
Do you want to show the values in EP like 04 or like 4?
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

Do you want to show the values in EP like 04 or like 4?

like 4
0
 
Martin LissOlder than dirtCommented:
I asked because this is similar to "Pair", and there it's "04".
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

 is an great point
by the way
i prefer tha same in column  BY
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
If possible
0
 
Martin LissOlder than dirtCommented:
Try this, BY was also changed.
29085944a.xlsm
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

is an Great Job !!

 
in the case of the MID
an little adjustment will be needed  different  like the week


i refer any
the  pair that show 2 or more time is needed  to be show  and count
0
 
Martin LissOlder than dirtCommented:
Are you talking about a new question?
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

is because
it show the pair with 3  or more repeat

but in this MID  from 2 are needed

can be an ew question for if you want?
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

Now i see the file
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Working As Needed

Best Expert !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.