can i modify the formula below to return all entries that do not contain "New Starter" and "Leaver"?
=IFERROR(INDEX(Employee, MATCH(0,INDEX(COUNTIF(B1:$B$1, Employee)+(COUNTIF(Employee, Employee)<>1),0,0), 0))," ")
where employee is a named range defined as
=OFFSET('Staff Details'!$A$3,0,0,COUNTA('Staff Details'!$A:$A)-2)
Last edited by Kramxel; 09-14-2015 at 06:53 AM.
Please post a sample file with expected results.
attached:
Column A is the original Data column B how I would like it look ideally however I would like to use whatever formula produces the results in column b to be used as a data validation drop down list.
The file you posted does not fit with your description in your original posting: no references to "New Starter" and "Leaver".
oops wrong file attached sorry
try now?
...Sorry ... same (wrong) file!!!
fingers crossed
I can't find a way to exclude those values (which doesn't mean it cannot be done!): if those are the only two, I would do it manually!
Maybe one of the gurus will respond with an answer.
if this was to be used by just me I would do exactly that John but the target end user isn't as erm... "Capable" so the more routes for error I can remove the better.
thank you for your response however.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks