Results 1 to 13 of 13

LARGE with IF Statement?

Threaded View

aeslabby LARGE with IF Statement? 05-01-2009, 11:20 AM
bill74 Re: LARGE with IF Statement? 05-01-2009, 11:42 AM
NBVC Re: LARGE with IF Statement? 05-01-2009, 12:00 PM
aeslabby Re: LARGE with IF Statement? 05-01-2009, 12:14 PM
NBVC Re: LARGE with IF Statement? 05-01-2009, 12:26 PM
NBVC Re: LARGE with IF Statement? 05-01-2009, 11:44 AM
aeslabby Re: LARGE with IF Statement? 05-01-2009, 11:57 AM
bill74 Re: LARGE with IF Statement? 05-01-2009, 11:47 AM
NBVC Re: LARGE with IF Statement? 05-01-2009, 01:10 PM
martindwilson Re: LARGE with IF Statement? 05-01-2009, 02:07 PM
NBVC Re: LARGE with IF Statement? 05-01-2009, 02:20 PM
martindwilson Re: LARGE with IF Statement? 05-01-2009, 02:26 PM
aeslabby Re: LARGE with IF Statement? 05-05-2009, 11:26 AM
  1. #1
    Registered User
    Join Date
    01-11-2007
    Posts
    6

    LARGE with IF Statement?

    Hi there!

    I need to create a "Top 5" list based on two columns. The example is as attached (the real list is approx 22 000 lines):

    I need to find the top 5 largest quantites (column A) for each flag catagory (column D) and include the part number and description. I have tried a pivot table and had some issues. Also tried a LARGE(IF...) type formula and still no luck. Does anyone have any ideas of what is the best way to do this??? I have a very short timeline and am struggling!

    Thanks!
    Attached Files Attached Files
    Last edited by NBVC; 05-05-2009 at 04:26 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1