Hi,
I have a sheet which serves as the master database for our orders. I am trying to make another sheet within the same workbook which will list any entries matching a specific value (i.e. "To Order"). I also need to list the start/end dates to the right of the entry.
Master Database
A: Item (lists articles of clothing
B: Status (Purchased, To Order, etc)
C: Start Date (date of which the action has been entered into database)
D: End Date (date of which the order is completed)
Filtered List
I want this to list everything with a status of "To Order", including the item, start & end dates.
I've come up with this formula, but it's not quite working properly: =IF(ISERROR(INDEX(data!$A$1:$D$7,SMALL(IF(data!$B$1:$B$7=$B$1,ROW(data!$B$1:$B$7)),ROW(1:1)),1)),"",INDEX(data!$A$1:DB$7,SMALL(IF(data!$B$1:$B$7=$B$1,ROW(data!$B$1:$B$7)),ROW(1:1)),1))
Sample file is attached. Any help would be greatly appreciated!
Cheers!
Bookmarks