Hi,
Here's what i need
Sheet name: DATA (assuming bob is on A1)
A B
Bob Proactive
Brenda Proactive
Jules Reactive
Alex Unknown
Jinny Unknown
Sheet name: Reference
N (which is my proactive column)
Bob
Brenda
I want a list of names in N which contains Proactive beside them. I will need the same formula for the rest (reactive and unknown), but i dont need it to be built. I just need the core formula and i will adapt. Need more details?
Last edited by xatomicx; 08-16-2017 at 01:53 PM.
.
Paste in N1 and drag down.
Please Login or Register to view this content.
c1=B1&COUNTIF($B$1:$B1,$B1) and drag down
n1=IFERROR(INDEX($A$1:$C$5,MATCH("Proactive"&ROW(),$C$1:$C$5,0),1),"") and drag down.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Thanks,
Logit your formula leaves blanks between results i need em on top of each other
Oeldere, trying this... standby.
None of them works,
oeldere i dont have a luxury of having a row C that i can spare, it needs to be one formula that does it all on ='Reference'!N1 :/
of course you can.
use in that case e.g. column Z for the helpcolumn.
Last edited by oeldere; 08-16-2017 at 03:32 PM.
Another way.
Array enter this formula in N1 and fill down until you get blanks.
If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.Formula:
Please Login or Register to view this content.
Dave
Or
Without array
Formula:Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks