3 Replies Latest reply on Nov 16, 2016 8:17 AM by Sherzodbek Ibragimov

    Can't get an INDEX to work properly

    Samuel Gee

      I have an INDEX() counting down some rows, and it all works perfectly. (Sheet 1)

       

      As soon as I add a T/F flag to the colours shelf though to highlight the products of a certain age, the index starts grouping together products based off no schema I can discern. I have no idea how to just make it count straight down the product list again.

       

      As ever, any help appreciated.

       

      Sam