count top repeat

need count the top repeat

by year

source column  H  is the count and column D  is the data counted

as show here

1aa.PNG
 


this the source
a1.PNG

file is here
Count_TOP_REPEAT_Fixed.xlsx
ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder than dirtCommented:
There is a value of 53 in E14. What is that?
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
I have to say coulmn I is the by year count of repeat
0
Martin LissOlder than dirtCommented:
I haven't looked at the new file, but try this. If it's what you want I'll add the code to the new file.
29087417.xlsm
1
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

it working as neded !
0
Martin LissOlder than dirtCommented:
Here is a version that uses the new file. The results look strange because there are many rows where column "I" is blank.

Also in some cases there is a 31 in column "H" (caused by a non-numeric character) and "7" in column "I". I'm not a formula expert but I believe that if you change the formula in column "H" to =COUNTIF($G:$G,"<=9") and the one in column "I" to =IF($H14>0,COUNTIF($G$6:$G$679,G14),"") that those values won't appear.
29087417a.xlsm
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
MArtin

I change the formula but is not
working as the first file you did
0
Martin LissOlder than dirtCommented:
I assume you are talking for example about the data under 2013 in ORD_TOP_YEAR. If so then look at this picture. It show the rows sorted by the value in column"H". Notice the 2013 days that I highlighted. There is no data in column "I" for those days and there are a lot more like that. That's why 2013 looks like it does.
2018-03-06_12-42-18.png
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

this file is corrected
Count_TOP_REPEAT_Fixed.xlsx
0
Martin LissOlder than dirtCommented:
There's more results now, but there are still a lot of blanks in column "I". Also as far as I can tell the formulas in "H" and "I" have not been changed. If you are going to update the data again then please use this workbook so I don't have to copy the code and add the button again.
29087417b.xlsm
1
Martin LissOlder than dirtCommented:
BTW, I assume you are getting the data from one of your main workbooks, so why not add the top count sheet to that workbook?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

is not corrected

may be I need xplain better  

In this question  i asking for take one count ALL

in column H ( imean just the higher )  then show the column  G


that the 2 column to work


and be show in

this area as show
a1.PNG
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin
I assume you are getting the data from one of your main workbooks, so why not add the top count sheet to that workbook?

this workbook need just be dedicated to top  only

because have to move fast to compare
0
Martin LissOlder than dirtCommented:
This looks better:)
29087417c.xlsm
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
11a.PNG
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

29087417c.xlsm file is better

but need the first 15 high values  from G

1- need look the high count numbers

then

2- we show only the values but not repeat
0
Martin LissOlder than dirtCommented:
we show only the values but not repeat
You never told me me that before, and, as a matter of fact you said above that
it working as neded !

Let me see what I can do.
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
i mean i need the higher  TOP from column G

we used the count in column H to knows wihch are the higher

but need have the first 15 values ( not repeat values) show in ORD_TOP_YEAR sheet
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin
You never told me me that before, and, as a matter of fact you said above that

You rigth

Remember the fisrt time  i ask
about to  

because I  Have an idea
as we keep going i undestand better how improve it
to get an better tool
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
hera in column H in NDTATOP sheet

is the count  

This count is showing to us

the higher  but it repeat the count for same number

and that ok

but  to analyze  i need see the higher and  
take it one time to move to the other repeat higer ( not only stay in one higer ORD)

 to know the ORD first higher
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
I have problems to express

what i see

because i cant not talk like the common way
0
Martin LissOlder than dirtCommented:
Write it in Spanish and then use google translate to get the English translation. But right now please let me get back to working on this question.
1
Martin LissOlder than dirtCommented:
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
aaa1111.PNG
0
Martin LissOlder than dirtCommented:
I have no idea where that came from. This is a picture of my results from 29087417d.
2018-03-06_14-16-56.png
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
MArtin


in  29087417d.xlsm

you point to 4617      9 as 9 times higher that ok  

im looking for the higher repeat

then

2813      8 times
4635      8 times


and not apear like that

why

we can not  goes to year 2012, not 2013 not 2014 yet

i will explain why and where im taking the values from
0
Martin LissOlder than dirtCommented:
I don't understand what you just said. Please write it in Spanish and translate to English.
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
MArtin

 Column H  formula is =COUNTIF($G:$G,G6)

this mean i will count all the times (years)

that why i call this section  here like that

11111bbbbbb.PNG
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
MArtin the

by year section will be other question  but
it comes from   column I  the formula from column  I is made by year
like this =COUNTIF($G$6:$G$679,G6)

g6 to g 679  is year 2012  only

then  for

year 2013  formula in  column I is  
=COUNTIF($G$680:$G$1355,G682)

g 680  to g 1355  make yea  2013  in column I
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin  at this question

we will work  all years

then we goes year by year top
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
but need  show  all the

higher from column H

8013      9 count times  
4617      9 count times
2813      8 count times
4635      8 count times
1379      7 count times
6607      7
2609      7
2037      7
2159      7



2 numbers in ORD column count 9 times  but only one is show ?

need be show all numbers that count 9

then 2 numbers in ord count 8 times
but  only one is show

need show all the numbers that count 8 times
after the 9 times
0
Martin LissOlder than dirtCommented:
Please write it in Spanish and translate to English.

I don't understand why you can't do that. Please send me a message if you don't know how to do that. I'm not going to do any more work on this until I 100% understand what you want, and currently I don't.

No entiendo por qué no puedes hacer eso. Por favor envíeme un mensaje si no sabe cómo hacerlo. No voy a hacer más trabajo hasta que entienda al 100% lo que quieres, y actualmente no lo hago.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

Im explaining as best i  can I have problems  with m language

lets beging  from 0 so i can have the chance to  goes point y point

please
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
1- column H have the count and show the higer in NDTATOP sheet

is ok ?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
2- column H show an numbers like

8013  repeat    9  times    


is ok?
0
Martin LissOlder than dirtCommented:
No.
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
MArtin

need to look  only 2 columns

column G  and column H   in NDTATOP sheet

is ok ?
0
Martin LissOlder than dirtCommented:
Try this.
29087417e.xlsm
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Great Best Expert !
0
Martin LissOlder than dirtCommented:
It was a long trip but we got there:)
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
be the best always take time !   ;)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.