top count 3nbase history

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:
Do I need to calculate columns G, H and I?  I don't understand the requirements. Please explain the requirements, using Google Translate to translate from Spanish to English.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

need find the top NUM in column L

column C have alredy the count then  select the TOp values (first 15 not repeat same NUM  )

then show the  Num that is assoicated to the top count (column L)
0
Martin LissOlder than dirtCommented:
Since there is a 4 in cell C7, does that mean that there are 621 4's in column C?
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

Since there is a 4 in cell C7, does that mean that there are 621 4's in column C

yes!!

c7=4   = 621



first step  is found the top values  in column C then from which one belongs in column L
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

in other way  621 had hit 4 times
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
column C tell how many times appear the numbres from column L

also have to say more data will be added

so all the column C will be used and L too
0
Martin LissOlder than dirtCommented:
OK so is it correct to say that 4 is the count of how many times 621 appears in the whole column?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin
OK so is it correct to say that 4 is the count of how many times 621 appears in the whole column?


yes!!
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

HIST_ALL_YEARS sheet is where to put the  answers

first 15 after hit the button
0
Martin LissOlder than dirtCommented:
Thanks.
1
Martin LissOlder than dirtCommented:
I can put the button on Sheet1 or on HIST_ALL_YEARS. Which do you prefer?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

I can put the button on Sheet1 or on HIST_ALL_YEARS. Which do you prefer?

i think  sheet 1 have too many buttons

that why i think  it will be better  HIST_ALL_YEARS
0
Martin LissOlder than dirtCommented:
Do you want results sorted by the history num? In other words do the ones I highlighted in red sorted followed by the ones I highlighted in yellow sorted? If so, high to low or low to high?
2018-03-27_15-59-51.png
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

that's will be great !

im agreed !!
0
Martin LissOlder than dirtCommented:
Which way; ascending or descending?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin


Which way; ascending or descending?

descending
0
Martin LissOlder than dirtCommented:
I guessed that:)
29091493.xlsb
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:
Martin


don't show the color effect to talk about
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
dd111.PNG
0
Martin LissOlder than dirtCommented:
I only added the color to explain the sorting. If you actually want colors then tell me which Style colors you want.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

as the sample you show will be ok
0
Martin LissOlder than dirtCommented:
Those colors are from the tool that I used to make the picture so I can't use them. How about this?
2018-03-27_16-33-42.pngIf you don't like those then pick two Excel Style colors that you want by going to Home->Styles tab and drop down the list. The two I chose are "Good" and "Neutral".

Actually I'd like to forget about colors because we could need up to 15 if all the COUNTs are different.
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

Those colors are from the tool that I used to make the picture so I can't use them. How about this?

yes! they are great  

im agreed
0
Martin LissOlder than dirtCommented:
When I said two colors I was mistaken. We could need 15 of them so I don't want to use colors at all.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

ok no problem
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Great Job !

Best Expert !
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 Excel

From novice to tech pro — start learning today.