Hi - I'm using the formula below to populate a list. I wondering can I use "LastRow" methodology for column BB in this formula? Can i get rid of the "0" at the end of the list in column AX, or is there a formula I can put in the validation that wouldn't include the "0" in the list?
{=IF(ROW(BB2:BB200)-ROW(BB2)+1>COUNT(AW2:AW200),"",INDEX(BB:BB,SMALL(AW2:AW200,ROW(INDIRECT("1:"&ROWS(BB2:BB200))))))}
Thanks!
{=IF(ROW(BB2:BB200)-ROW(BB2)+1>COUNT(AW2:AW200),"",INDEX(BB:BB,SMALL(AW2:AW200,ROW(INDIRECT("1:"&ROWS(BB2:BB200))))))}
Thanks!
Last edited: