Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...
MS Office Forum / Excel / Worksheet Functions / June 2007

Tip: Looking for answers? Try searching our database.

Show Top 10 with array formula

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jen - 30 Jun 2007 00:23 GMT
Hello there,

Would it be possible to evaluate A1:A2000 and show me the top 20 values in
B1:B20  ...with an array formula?

I think to have seen it the other day, but I cannot reproduce nor find it
...

Jen
Reply to this Message
Mike H - 30 Jun 2007 09:40 GMT
Jen,

What do you want an array for? Put this in B1 and drag down 20 rows for the
top 20 values.

=LARGE(A$1:A$2000,ROW())

Mike

> Hello there,
>
[quoted text clipped - 5 lines]
>
> Jen
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.