ColA – LNames (Original list, all my employees)
ColE – Displays only the names of people who work on Monday. Array with
formula =INDEX(LNames,SMALL(IF(ISNA(MATCH(LNames, Monday,0)),
ROW(LNames)),ROWS(E$2:E2))-MIN(ROW(LNames))+1) that you so kindly helped me
with
I use the counter for the formula in ColG so when I select a name in my
datavalidation drop down list the names disappear as I go down the list.
Pete_UK referred me to a website about Excel Data Validation -- Hide
Previously Used Items in Dropdown and that is where I got the formula for
ColG.
My goal is to create a dropdown list that has only the names of the people
who work on that day and have those names disappear from the list as you
select them so only 1 employee per assignment. As I'm approaching my goal, I
now have this issue of extra data in my list because I want it to be
expandable. If you have a better plan than what I did, any ideas are
appreciated.
Thanks.
"T. Valko" wrote:
=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.
.