I have a named range "EmpList" it gets it information from column F. In Column G, it states whether or not the employee in F is on the active roster.
I would like the list to include only those names on the active roster.
I am currently using the formula
=OFFSET(Schedule!$F$341,,,COUNTA(Schedule!$F$341:$F$1000),1)
Any assistance is greatly appreciated.
Last edited by ZooTV92; 08-21-2011 at 08:23 PM.
Hi, Try COUNTIF instead of COUNTA,
=OFFSET(Schedule!$F$341,,,COUNTIF(Schedule!$F$341:$F$1000,"?*"),1)
Or please attach a dummy file.
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
not sure but try this
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thank you for the quick responses.
I used Martin's example and it works perfectly.
Have a great day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks