Results 1 to 2 of 2

Using formulas to extract data meeting 2 specific criteria

Threaded View

Levie Using formulas to extract... 11-01-2012, 08:51 PM
martindwilson Re: Using formulas to extract... 11-01-2012, 09:27 PM
  1. #1
    Registered User
    Join Date
    04-05-2012
    Location
    brisbane
    MS-Off Ver
    Excel 2010
    Posts
    4

    Using formulas to extract data meeting 2 specific criteria

    EDIT: Nevermind I'm retarded and didn't hit ctrl+Shift+Enter for the arrays DOH! mods please delete

    I've a massive table which serves as the warranty database for my company, I've been asked to try and extract data monthly for a particular brand of product. I found this tutorial
    http://www.youtube.com/watch?v=9jmNE...A7644FE57C97F4
    which pretty much is exactly what I need! I decided to work from a mini data set at the moment just so I can get my head around the formula and I've managed to get the count formula working however my extraction formula ends up with #VALUE! . I've double checked it and going from the video I can't find any code errors; can you guys please take a look and tell me if you see anything amiss?

    =IF(ROWS(A$7:A7)>$A$5,"",INDEX(A$25:A$44,SMALL(IF((($A$25:$A$44>=$A$2)*($A$25:$A$44<=$B$2)*($B$25:$B$44=$C$2)*($B$25:$B$44<>"")),ROW($A$25:$A$44)-ROW($A$25)+1),ROWS(A$7:A7))))

    A2:C2 are my criteria values
    A5 is my count formula
    A7 is the start of my extracted data
    A25:D44 is my original data set
    Last edited by Levie; 11-01-2012 at 08:54 PM. Reason: I'm an idiot!

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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