Hi all, I'm hoping someone is able to advise if there is a formaula able to select a range of cells starting from the very bottom cell in a column, which contains a value, and is visible within a filtered column, up 25 cells. This is so that a formula I have only looks in that range, which is from the bottom cell to the 25th cell above in a single row. To give a bit more information, I have an existing fomula that inputs a range of cells as one of its parameters. However, I'm looking for that range input to be be from the very last value in a column to (and including) 25 cells up towards the top. Is this possible? Thanks in advance.