Function AGGREGATE and FREQUENCY

[XLalbania]

Hello excel Gurus
thi formula works very well and since I have excel 2013 i need this formula with AGGREGATE, do you think is possible?

=IFERROR(INDEX(B$3:B$52,SMALL(IF(FREQUENCY(IF($C$3:$C$52<>"",IF($B$3:$B$52>=$G$2,IF($B$3:$B$52<=$H$2,MATCH($B$3:$B$52&$C$3:$C$52&$D$3:$D$52,$B$3:$B$52&$C$3:$C$52&$D$3:$D$52,0)))),ROW($B$3:$B$52)-ROW($B$3)+1),ROW($B$3:$B$52)-ROW($B$3)+1),ROWS(J$3:$K3))),"")
thank you!

[newdoverman]

I don't know what it is that you want from AGGREGATE that you don't get from your existing formula. This however seems to return the same values as you formula and it is shorter.

Please Login or Register  to view this content.

Even shorter is this version

Please Login or Register  to view this content.

[XLalbania]

Hello newdoverman
thank you for yor answer, sorry if i answered you a bit late, I was busy working, thank you for the better formula but still I'm looking for something with AGGREAGATE that normally avoid to press CTRL+SHIFT+ENTER Im very courius if this is possible
Thanks for yor help!

[XLalbania]

Edit threads

[XLalbania]

Edit thread

[newdoverman]

Test this out as it seems to work with the dummy worksheet that I set up but it may not match what you have.

Please Login or Register  to view this content.

[XLalbania]

thanks for he answer

[newdoverman]

You're welcome.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[XLalbania]

@newdovermann
I tried to put an atthachment but not working for thi forum (trouble with Atthach)
any way the answer is not what i was looking for
thank you for now and i prefer keep this thread open
bye

[newdoverman]

I don't know what it is that you are looking for. You stated that your original formula was working very well. The formula that I gave you that uses AGGREGATE produces exactly the same result with data that I used with dummy data.

What is it that you are looking for and not getting?