+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 21 of 21

Data Required in a easy way in a complex file.

  1. #16
    Registered User
    Join Date
    12-08-2018
    Location
    pakistan
    MS-Off Ver
    2010
    Posts
    89

    Re: DATA required in a easy way

    please see my new TITLE.

  2. #17
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    45,946

    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.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #18
    Registered User
    Join Date
    12-08-2018
    Location
    pakistan
    MS-Off Ver
    2010
    Posts
    89

    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.

  4. #19
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    45,946

    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?

  5. #20
    Valued Forum Contributor Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    BKK, Thailand
    MS-Off Ver
    Excel2016
    Posts
    1,215

    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))),"")
    Attached Files Attached Files
    Bo

  6. #21
    Registered User
    Join Date
    12-08-2018
    Location
    pakistan
    MS-Off Ver
    2010
    Posts
    89

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

    Thanks a lot Bo_Ry.

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1