=IF(ROW(FilteredMonday)-ROW(E2)+1COUNT(F2:F100),"",
INDEX(E:E,SMALL(F2:F100,ROW(INDIRECT("1:"&ROWS(Fi lteredMonday))))))
ColF = counter
rows 44-100 are either a 0 or #NUM!.

Isn't that why you have this portion of the formula:

=IF(ROW(FilteredMonday)-ROW(E2)+1COUNT(F2:F100),"",

What is the col F counter for?


--
Biff
Microsoft Excel MVP


"Lost Cluster" wrote in message
...
In ColumnG I have the following formula array from row2 all the way down
to
row100

=IF(ROW(FilteredMonday)-ROW(E2)+1COUNT(F2:F100),"",
INDEX(E:E,SMALL(F2:F100,ROW(INDIRECT("1:"&ROWS(Fil teredMonday))))))

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.