technician12
10-01-2020, 10:42 PM
Hello.
I've been tinkering with making a dynamic list, but i might be going the wrong way about it.
If you see the sample workbook, Theres a problem in C14.D14, even though the cell in "blank" its not a true blank cell, therefore its still counted and numbered, resulting in a "hole" in the generated list ( Based on J10:J17 ), that's being used in F4.
Any way to make the "blank" cell not counted and therefore the list being without these holes ?
27255
I've been tinkering with making a dynamic list, but i might be going the wrong way about it.
If you see the sample workbook, Theres a problem in C14.D14, even though the cell in "blank" its not a true blank cell, therefore its still counted and numbered, resulting in a "hole" in the generated list ( Based on J10:J17 ), that's being used in F4.
Any way to make the "blank" cell not counted and therefore the list being without these holes ?
27255