Hi All,
coming to this forum is actually always give me a relief, because i know i'm going to get the slolution.
actully i've excell sheet,
where column A has the names, columns B has the Number and Column C has the status.
name number Status a 2 Pass b 0 fail
and i've selected one cell where i'll put the formula and i'll get the name of Pass candidate.
any idea Guys
Will there only be one Pass in list (I suspect not)?
Do you want to return everyone who has a Pass?
What's your output look like if returning everyone who has a Pass?
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Thanks K for taking your precious time on my issue
you are right i have a huge list of pass and fail candidates.
my main motto is to hide those columns only one cell be visible which will have the formula and that will fetch all the data( names of all) of pass candidates.
Try
in D1
=IFERROR(INDEX($A$1:$C$1000,SMALL((IF($C$1:$C$1000="Pass",ROW(INDIRECT("1:"&ROWS($A$1:$A$100))))),ROW(A1)),1),"")
Array formula, use Ctrl-Shift-Enter
and copy down the column
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks