Formula which will account for increase in last cell value and display an "X"

[JulianS96]

Hi Forum, me again
Just a quick query.
Wondering if it's possible to make excel expand the cell range depending if I expand the list with a non blank cell.
E.g. Currently the list is CHECK CLEAN OPEN etc. if i added TRUE onto the end would i be able to have some formula such as

Please Login or Register  to view this content.

added into

Please Login or Register  to view this content.

such that

Please Login or Register  to view this content.

If not, just let me know
Thanks,
Julian

[JulianS96]

EDIT: Fixed it myself with OFFSET:

Please Login or Register  to view this content.

[6StringJazzer]

Thanks for sharing your solution. If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

[JulianS96]

Link to dynamic cell range: https://exceljet.net/formula/dynamic...ge-with-offset