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.
HTH; Haseeb
If your problem is solved, please say so clearly, and mark your thread as Solved:
Forum Rules & How to Mark a thread as SOLVED
not sure but try this
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
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
Reply With Quote
Bookmarks