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
Formula:
=ADDRESS(MATCH("zzz", O:O), 15, 1, 1)
added into
Formula:
=IF(SUMPRODUCT(--ISNUMBER(SEARCH($O$2:$O$15,$C2)))>0,"X","")
such that
Formula:
=IF(SUMPRODUCT(--ISNUMBER(SEARCH($O$2:ADDRESS(MATCH("zzz", O:O), 15, 1, 1),$C2)))>0,"X","")
If not, just let me know
Thanks,
Julian
Bookmarks