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
Bookmarks