# Data Required in a easy way in a complex file.

1. ## Re: DATA required in a easy way  Register To Reply

2. ## Re: Set File as per DATA required

Without seeing what you want to do, I cannot say if that title is more descriptive or not, sorry.  Register To Reply

3. ## Re: Set File as per DATA required

i changed new tiltle in title thread, but not showing?
Title:
Data Required in a easy way in a complex file.  Register To Reply

4. ## Re: Set File as per DATA required

Yes, I can see you changed the title (you need to do it in the 1st post though)

Sorry to be such a pain, but I am still waiting to see you describe what your question is, and what you expect?  Register To Reply

5. ## Re: Set File as per DATA required

Please see the correction in blue.

G2
=IFERROR(IF(COUNTIF(G\$1:G1,LOOKUP("z",A\$2:INDEX(A:A,AGGREGATE(15,6,ROW(A\$2:A\$102)/MMULT(--(LEFT(\$B\$2:\$B\$102)={"m","s","r","y"}),{1;1;1;1})/ISNUMBER(\$D\$2:\$D\$102),ROWS(G2:G\$2))))),"",LOOKUP("z",A\$2:INDEX(A:A,AGGREGATE(15,6,ROW(A\$2:A\$102)/MMULT(--(LEFT(\$B\$2:\$B\$102)={"m","s","r","y"}),{1;1;1;1})/ISNUMBER(\$D\$2:\$D\$102),ROWS(G2:G\$2))))),"")

H2
=IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW(B\$2:B\$102)/MMULT(--(LEFT(\$B\$2:\$B\$102)={"m","s","R","y"}),{1;1;1;1})/ISNUMBER(\$D\$2:\$D\$102),ROWS(B2:B\$2))),"")  Register To Reply

6. ## Re: Data Required in a easy way in a complex file.

Thanks a lot Bo_Ry.  Register To Reply