LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Dan
 
Posts: n/a
Default Large() with twist

Hello,
I am interested in returning the name(s) of a product if it is one of the
top 5 money makers for the year. I believe the large() can return me the top
5 products but 1) what if two or more products have the same value (for
example see below how the top money maker is 500 but it is for both Product A
and Product C) and 2) how do I return both the names of the products that
meet this condition? In summary, so even though I want the Top 5 products,
there could be more than 5 products because some products have the same value
but I want to list out all the products that meet these conditions.
Please help

Thank you,
Dan

Ex.

Product $

Product A 500
Prodcut B 100
Product C 500
Product D 400
Product E 300
Product F 200
Product G 100
Product H 100
....

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Not enough memory for large workbooks Kevin Excel Discussion (Misc queries) 3 January 21st 05 10:29 PM
Match, Index, Vlookup, Large....Help Please [email protected] Excel Worksheet Functions 3 December 15th 04 01:38 PM
Excel should be able to compute the MOD of large numbers. Gold Fish Excel Worksheet Functions 5 December 3rd 04 09:10 AM
How can I combine IF, COLUMN, and LARGE formulas in a single cell? Liam Judd Excel Worksheet Functions 1 November 17th 04 07:52 AM
finding common numbers in large lists Jenn Excel Worksheet Functions 1 November 11th 04 07:42 PM


All times are GMT +1. The time now is 07:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"