count each number column

column
DY  DZ  

is the each count number

from column BF

asasasasas11111111.PNG
0001101010101.PNG678965456.xlsx
ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?
 
Martin LissConnect With a Mentor Older than dirtCommented:
Please look at this carefully at this workbook, particularly in the range DY5:DZ15. If that data or any other is incorrect then please let me know,
29081674c.xlsm
1
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Like so?
Click the button called "Count Numbers" to populate columns DY and DZ.
678965456.xlsm
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Subodh Tiwari (Neeraj) Great Expert !

 Glad to see you back !!

where to click ??
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Sorry! I forgot to attach the file. In the file, on Sheet1, you will find a button called "Count Numbers" placed in column ED.
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Subodh Tiwari (Neeraj) Best  Expert !

Thanks for the fast reponse

in  this situation

i need count each number in the 13 set (1week)
then show the  numbers as  the order it happens

let me explain an sample

1- if we goes to week 13W2014

then you see

aaaaaaaa1111111111111111111.PNG

what i need in column
DY  DZ  

is the each count number
which will give the top number

in the order that happens

asasasasas11111111.PNG

this the results
after the count
00000001111111111.PNG
im using this  tools for count
each column but need  an more fastest way to complete the task
count-each-number.xlsm
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Can you mock up the desired output for few rows manually and upload the file again?
0
 
Martin LissOlder than dirtCommented:
Try this. Run the DY_DZ macro that you'll find in Module1.
29081674.xlsm
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
i take 12w2014 as sample  look  please as here
a0.PNG

then  i take the data as here
a1.PNG

then  have to be copied to be count ( i want this to be directly in the file


a2.PNG

then  paste the result in the file  

a3.PNG


then need have the data show as here

a4.PNG

this the file with the sample
678965456--1-.xlsx
0
 
Martin LissOlder than dirtCommented:
Did you try my code?
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Subodh Tiwari (Neeraj)

Please let me know if i  make an good explain until now
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin Liss

im
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
It seems that Martin guessed your requirement correctly. Please check the file he uploaded.
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Subodh Tiwari (Neeraj)

Thanks for the  help
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome Adriana!
1
 
Martin LissOlder than dirtCommented:
This version has a button. You'll find it near columns DY:DZ.
29081674a.xlsm
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin Working for me

have an question

can be the 2 first to post as needed

and first 3 in the  correct cell ??


like here
a4.PNG
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
and here

0001101010101.PNG
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin
i can open new question for
0
 
Martin LissOlder than dirtCommented:
Try this.
29081674b.xlsm
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

 Great JOB

 Best Expert Ever !!
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
I want to consult you a small issue


but working great


when in top  cpunt is example 05    it show just 5   need be show as 05
0
 
Martin LissOlder than dirtCommented:
If you format column EA as Text, you will see 05.
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Working as needed !!

Great Job !
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Are you getting the correct output with Martin's solution?
See his latest file and look at the cell DY13. It shows the count of 5 is 5 in DZ13 while I don't see 5 in numbers in the range BF6:BF16.
Or I am missing something?
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Subodh Tiwari (Neeraj)

let  me check it please and thanks for the  point
0
 
Martin LissOlder than dirtCommented:
  • The numbers in column DY are the single-digit numbers contained the BF column in any give week.
  • The numbers  in DZ are the number of times the number in DY occurs. DY/DZ is sorted on DY.
  • The numbers in EA in the '1- row' are a concatenation of the first two DFY values.
  • The numbers in EA in the '2- row' are a concatenation of the first three DFY values.
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Subodh Tiwari (Neeraj)


as i see you point the only diference is the sort

in my original  files sort are from minor to  mayor

with martin solution is from mayor to minor


but   is  working as expected

becasuse all will be the same   ((i mean the same pattern)


but let me know if you  need more information
or  suggestion  from you will be welcome always

Great Expert
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
i mean the sort   when an count repat as  in DY 13 case

3 numbers count 3 times
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
b1.PNG
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Obviously I am missing something here.
This is what I understood regarding your requirement.

For each week in column B, count the occurrences of all the single digits used in the numbers in the range BF6:BF16. Right?
So the DY5:DY14 should contain all the single digits found in the range BF6:BF16 and DZ5:DZ16 should contain the occurrences of each single digit listed in DY 5:D14, of course after sorting them in descending order on column DZ. Right?

Or the requirement is something else. Lol
Sorry! If I am not getting it. :)
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
apart the sort  

all is working as needed


but welcome any idea from you
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Subodh Tiwari (Neeraj)

i will help you get it  let me explain
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Can you just explain why DY13 and DZ13 contain 5 in them?
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
For each week in column B, count the occurrences of all the single digits used in the numbers in the range BF6:BF16. Right?

yes you rigth


one week  then count all the digit of that week
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
That's what I am asking. Where is the 5 in BF6:BF16?
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Subodh Tiwari (Neeraj)

Can you just explain why DY13 and DZ13 contain 5 in them?

Yes  !!

Im looking for the top  repeat only in this situation
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
as  the first 2 digit  are  for my

the top pair

and the first 3 digit are

then an 3 digit  top

then thats what;s i need
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Subodh Tiwari (Neeraj)

let me know is  you get it


after all the count the most
repeat are my  guide to work with
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Never mind. It hardly matters if I am not able to understand your requirement as it seems to be a tricky one. :)
But the point is you have got a working solution. :)
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
the count show in vertical way
let me see the most
2 repeat then the 3 most repeat

then i use like an mark
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
That's okay Adriana!
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
after see then vertically

i then put horizontally

but the first 2  and first 3

because that make an mark to follow
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Subodh Tiwari (Neeraj)

I hope you keep the great job and you always welcome!
any time any question
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Thanks for addressing the point Martin! Much appreciated.
All I want to know that why there is 5 in DY13 and DZ13?
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
So the DY5:DY14 should contain all the single digits found in the range BF6:BF16 and DZ5:DZ16 should contain the occurrences of each single digit listed in DY 5:D14, of course after sorting them in descending order on column DZ. Right?

yes
0
 
Martin LissOlder than dirtCommented:
Neeraj , most the the weeks seem to be correct, but in the range you mention, there is an error since there are no 5's so DZ13 should be zero. Let me take a look.

When I fix it I'll be happy to have the question opened again so we can split the points.
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Subodh Tiwari (Neeraj

you rigth something when wrong here
b2.PNG
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
It took long to get the issue I was talking about. Was I so bad in explaining it? :)
0
 
Martin LissOlder than dirtCommented:
Neeraj, please see post ID: 42454529. I dleted the original one and reworded post ID: 42454529.
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
should be like this

b3.PNG
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Yes, I saw that post Martin.
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Subodh Tiwari (Neeraj)


don't say that

im not an expert like yours

but glad you area around

MArtin i know try to make a fast solution
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Here is the file. Please click the button "Count Numbers' to populate columns DY:DZ.
GetNumerCount.xlsm
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
@Adriana

I am questioning myself not anybody else.  :)
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
:) i know
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Great! :)
Did you check the file I uploaded?
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Subodh Tiwari (Neeraj)

Yes is working as should be !!

can  help with 2 minor issues

1- the sort can be minor to mayor when repeat count are ??

2- can be  the first 2  and first 3 be show  ?
0
 
Martin LissOlder than dirtCommented:
I'm sorry but while my solution isn't totally correct, I don't thing Neeraj's is either. I his workbook take range BF1512 to BF!523. There are 8 4's in that range, so cell DZ1513 should be 8 and not 7. Unless I don't understand what's needed.
1
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
1- the sort can be minor to mayor when repeat count are ??
Right now the sort order is Descending on column DZ. Do you want it to be in Ascending order?

2- can be  the first 2  and first 3 be show  ?
Can you explain this? Do you want to show only top 2 in column DY:DZ?

Run the code in the file I uploaded, delete the values from DY4:DZ11 and manually show your desired output then.
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
1- i mean the sort of the number show by the count

example here  

b1.PNG
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
9
6
2

count 3 times the same
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
b4.PNG
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
then the order of the digit  should be

2
6
9
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
2- can be  the first 2  and first 3 be show  ?
Can you explain this? Do you want to show only top 2 in column DY:DZ?

b5.PNG
0
 
Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
You're right Martin.
Fixed that issue.
GetNumerCount-v2.xlsm
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
column EA need show the top horizontally
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
@Adriana

It is 1:17 AM here so I will log off now and will look at it tomorrow. Hope that's fine with you. :)
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
You are 2  are the best !! Expert

you 2 understand  my solution need

some times is not that easy
but working togheter

make the great difference
1
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Tomorrow I will let you know if I need you to explain anything else.
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Subodh Tiwari (Neeraj)

yes for sure i really apreciatte you  time and big help

have a good rest !
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Thanks Adriana!
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

you with me always

i know you doing the best not now but always
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Working as needed ! Martin
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin will need the same but in column
DC  AND DD
0
 
Martin LissOlder than dirtCommented:
I'm glad you have what you need for DY:DZ and I think DC/DD should be a new question. Please request attention for this question and have a moderator reopen the question so that you can give part of the points to Neeraj.
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Best Experts  !!!

 Great JOB !!
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.