L
Lost Cluster
In ColumnG I have the following formula array from row2 all the way down to
row100
=IF(ROW(FilteredMonday)-ROW(E2)+1>COUNT(F2:F100),"",
INDEX(E:E,SMALL(F2:F100,ROW(INDIRECT("1:"&ROWS(FilteredMonday))))))
ColE = FilteredMonday (a list of my employees who work on Mondays)
ColF = counter
In ColumnM I have a drop down list with data validation and the source for
it is ColumnG. The problem is I only have 43 names but I wanted it to have
the capacity for 100 names, so rows 44-100 are either a 0 or #NUM!. How can
I have the drop down list show only the names without cutting short my list
in case I do decide to add more names later on?
Thank you.
row100
=IF(ROW(FilteredMonday)-ROW(E2)+1>COUNT(F2:F100),"",
INDEX(E:E,SMALL(F2:F100,ROW(INDIRECT("1:"&ROWS(FilteredMonday))))))
ColE = FilteredMonday (a list of my employees who work on Mondays)
ColF = counter
In ColumnM I have a drop down list with data validation and the source for
it is ColumnG. The problem is I only have 43 names but I wanted it to have
the capacity for 100 names, so rows 44-100 are either a 0 or #NUM!. How can
I have the drop down list show only the names without cutting short my list
in case I do decide to add more names later on?
Thank you.