top count 3nbase history

ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?
 
Martin LissConnect With a Mentor Older than dirtCommented:
I guessed that:)
29091493.xlsb
1
 
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
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:
Since there is a 4 in cell C7, does that mean that there are 621 4's in column C?
0
 
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
 
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
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.