count num as high

count num as appear with the top count first

all column will be used as needed



a1.PNGhighcount_to.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:
You didn't attach a workbook.
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

 Thanks  ! now on !
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

i have to say can be an 2n 3n 4n as needed
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.

Martin LissOlder than dirtCommented:
The workbook you posted does not have 4n data.
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin


this an 4n  in sheet2


b1b1.PNG
this an  3n in sheet1

c1c1c1.PNG
2n is now  not show


but can be all an one  sheet  
so it work with 2n 3n and 4n as needed ?
Martin LissOlder than dirtCommented:
Yes it can. But it worries me when you say "all column will be used as needed". Why not just modify the attached workbook so that it also works for 4n?
29092092.xlsm
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin


yes ! it can be

is an better idea and thanks


all column will be used as needed"


i say wrong what i mean is that i can put data all over the columns as needed to be count

for example
data will be put  in column B and C

then is not limit of data that will be put in  column an B and C
data can shrink or grown as needed
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

in the 29092092.xlsm
file an sheet to count the high as needed
will help
Martin LissOlder than dirtCommented:
In your picture you show 6379 three times. Why?
2018-04-03_15-48-11.png
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

that's  what i need count

the high count  is my target

they belong from  diferrentes sources
Martin LissOlder than dirtCommented:
Before we go any further I need a complete explanation of what you need because "count num as appear with the top count first all column will be used as needed" doesn't really tell me anything. Say it in Spanish first and then translate into English.
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

best expert !!

you see how many times  6379 ??

are 9 times

that waht i need  to be show in colulmn H and I

then that the same for all numbers



but in descending order ( higher to lowest ) in column I  (where the count is)




b1b1.PNG
b1b1.PNG

please let me know is explaining as needed
Martin LissOlder than dirtCommented:
I'm sorry Adriana, but i'm going to skip this one.
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
ok
ShumsExcel & VBA ExpertCommented:
Hi Adriana,

Check attached and let me know. I do not see 3579 appearing just 7 times.
Kindly note, I have deleted first blank cells after headers, secondly Excel is not reading numbers in NUM column as numbers, so I have formatted those cells.
Adriana_highcount_to_v1.xlsm

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 Job !

Best  expert
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
working as needed
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 Office

From novice to tech pro — start learning today.