LinkBack URL
About LinkBacks
I attached an edited version of your workbook that contains the formula I posted.
Does that help?
I attached an edited version of your workbook that contains the formula I posted.
Does that help?
Thats as I thought. The only thing that changes from Column A to B is the A or B i.e.
.......*"&A$2
.......*"&B$2
When I have put into my new workbook I have the following 2 formulas:
Column A:
Column B:
=IF(COUNTIF(RESULTS_RR!$AO$3:$AO$40,"*"&A$2)>=ROWS($3:3),INDEX(RESULTS_RR!$A$3:$A$40,SMALL(INDEX((RIGHT(RESULTS_RR!$AO$3:$AO$40,1)=A$2)*ROW(RESULTS_RR!$AO$3:$AO$40),0),ROWS($3:3)+COUNTIF(RESULTS_RR!$AO$3:$AO$40,"<>*"&A$2))),"")
RESULTS_RR!$AO$3:$AO$40 is where my CURRENT PHASE column is.=IF(COUNTIF(RESULTS_RR!$AO$3:$AO$40,"*"&B$2)>=ROWS($3:3),INDEX(RESULTS_RR!$A$3:$A$40,SMALL(INDEX((RIGHT(RESULTS_RR!$AO$3:$AO$40,1)=B$2)*ROW(RESULTS_RR!$AO$3:$AO$40),0),ROWS($3:3)+COUNTIF(RESULTS_RR!$AO$3:$AO$40,"<>*"&B$2))),"")
B$2 is where my PHASE TITLE is to look up.
RESULTS_RR!$A$3:$A$40 is where my PROJECT NAME column is.
...?
dvent
After adjusting references, I found the flaw in your formula....
SoThis section: INDEX(RESULTS_RR!$A$3:$A$40 Should be: INDEX(RESULTS_RR!$A$1:$A$40
Copy that formula across and down.A3: =IF(COUNTIF(RESULTS_RR!$AO$3:$AO$40,"*"&A$2)>=ROWS($3:3), INDEX(RESULTS_RR!$A$1:$A$40,SMALL(INDEX((RIGHT( RESULTS_RR!$AO$3:$AO$40,1)=A$2)*ROW(RESULTS_RR!$AO$3:$AO$40),0), ROWS($3:3)+COUNTIF(RESULTS_RR!$AO$3:$AO$40,"<>*"&A$2))),"")
Done, yet?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks