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

count each number in pair

column
DR  DS

is the each count number

from column Bx

n1.PNG29081772.xlsm
0
ADRIANA P
Asked:
ADRIANA P
  • 5
  • 4
1 Solution
 
Martin LissOlder than dirtCommented:
Try this.
29081910.xlsm
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
MArtin Working as needed !
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
then need the tri
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
Martin LissOlder than dirtCommented:
Please ask a new question.
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Great JOB

Best Expert !
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin when  pair top
don't have data (  imean column BX  )

it show an number  in DT column

but cero count is happening because is blank

that can be fixed ?
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
R1.PNG
here the file because i added an  new section

MArtin
29081932bbbb.xlsm
0
 
Martin LissOlder than dirtCommented:
All the '...Top' buttons with the exception of Triple Top which I've corrected, will have the same problem. I'll be back.
1
 
Martin LissOlder than dirtCommented:
OK in this workbook I've done two things to each of the four '...Top' buttons:
  1. Added code that clears the output columns before the rest of the code runs. Otherwise changes to the source data may not show up in the output.
  2. Added code to each of the four '...Top' button like that in Triple Top, which if all the data for a week is zero or blank then the output will be blank.
29081910a.xlsm
1
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).

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