OK, so i have been trying to pull data that is in between two times of the day and have hit a bump in the road.
I need to split data up between 3 shifts based on the time a finished goods was made.
export1.xlsx
i have been trying to get this formula to work but just cant get it working properly
=index($A$2:$A$29,SMALL(IF($A$2:$A$29>=$F$1,IF($A$2:$A$29<=$G$1,ROW($A$2:$A$29)-ROW($A$2)+1)),ROWS(E$2:E2)))
Thanks
Edit: My apologies Edited Thanks FDibbins
Bookmarks