check date criteria and match

    You'll have to make Table 3 as large as you think you will ever need to show all results. It won't auto expand/contract...


    In A2 enter Array* formula:


    =IFERROR(INDEX(Table1[NAME],SMALL(IF(Table1[DATE]=$G$3,ROW(Table1[DATE])-MIN(ROW(Table1[DATE]))+1),ROWS(A$2:A2))),"")


    and in B2


    =IFERROR(INDEX(Table1[TOTAL FEE],SMALL(IF(Table1[DATE]=$G$3,ROW(Table1[DATE])-MIN(ROW(Table1[DATE]))+1),ROWS(A$2:A2))),"")


    copied down as far as you need to get all possible data.


    [arf]*[/arf]

    Where there is a will there are many ways. Finding one that works for you is the challenge!

    thank you, it worked but pls it seems like there are irregularities in my date in table 1, how do i make a date column to pick the date format.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login