• Status: Solved
  • Priority: High
  • Security: Public
  • Views: 51
  • Last Modified:

MID TRI count 4N

column BF is the source

then need from the half set   (monday  to wednesday)


  the  TRI repeat (2 or more needed)

 for each set (6 rows)
and show in column   EY  and the count in column EZ

as show  here
1a.PNG29086093_4n_MID_range_working.xlsm
0
ADRIANA P
Asked:
ADRIANA P
  • 4
  • 4
1 Solution
 
Martin LissOlder than dirtCommented:
Try this.
29086202.xlsm
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin
 Are you getting fastter ?
0
 
Martin LissOlder than dirtCommented:
This was very much like the Triple code.
1
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin  

GREAT JOB EXPERT

I know i just  want to  make an good  smile !   :)


I have this situation  working with the file

as show here

 this is the  results
c1.PNG

from here

b1.PNG

Please can  you !!
0
 
Martin LissOlder than dirtCommented:
In my code that checks if the numbers are in 2,6,8,0... order I said that if the 3 numbers were all even numbers that unless each digit was less than the one that followed it, it was NOT in the right order. And so while 246 would be OK, a number like 240 or 260 would not be because mathematically 0 is less than 6.  I've changed that logic so that now it seems to work correctly, but please carefully check both 'Triple MId' and 'Triple' because they both share that code.
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

where is the file?
0
 
Martin LissOlder than dirtCommented:
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Great JOB !

Working as needed !
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now