# top count 3nbase history

###### Who is Participating?

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.

Older 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
ACCOUNTING 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
Older than dirtCommented:
Since there is a 4 in cell C7, does that mean that there are 621 4's in column C?
0
ACCOUNTING 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
ACCOUNTING ASSISTANTAuthor Commented:
Martin

in other way  621 had hit 4 times
0
ACCOUNTING 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
Older 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
ACCOUNTING 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
ACCOUNTING ASSISTANTAuthor Commented:
Martin

HIST_ALL_YEARS sheet is where to put the  answers

first 15 after hit the button
0
Older than dirtCommented:
Thanks.
1
Older than dirtCommented:
I can put the button on Sheet1 or on HIST_ALL_YEARS. Which do you prefer?
0
ACCOUNTING 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
Older 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?
1
ACCOUNTING ASSISTANTAuthor Commented:
Martin

that's will be great !

im agreed !!
0
Older than dirtCommented:
Which way; ascending or descending?
0
ACCOUNTING ASSISTANTAuthor Commented:
Martin

Which way; ascending or descending?

descending
0
Older than dirtCommented:
I guessed that:)
29091493.xlsb
1

Experts Exchange Solution brought to you by

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

ACCOUNTING ASSISTANTAuthor Commented:
Martin

don't show the color effect to talk about
0
ACCOUNTING ASSISTANTAuthor Commented:
0
Older 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
ACCOUNTING ASSISTANTAuthor Commented:
Martin

as the sample you show will be ok
0
Older than dirtCommented:
Those colors are from the tool that I used to make the picture so I can't use them. How about this?
If 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
ACCOUNTING 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
Older 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
ACCOUNTING ASSISTANTAuthor Commented:
Martin

ok no problem
0
ACCOUNTING 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.