Unique with sort ignoring criteria

[mecerrato]

I am using the following formula to create a unique list with 2 conditions, the formula works fine:
=UNIQUE(FILTER('Credit Pulls'!$E$2:$E$150000,('Credit Pulls'!$D$2:$D$150000=Summary!M17)*('Credit Pulls'!$AI$2:$AI$150000 >0)))

However, I also ant to sort the list, but when I add the sort part to the formula it ignores my second criteria
=SORT(UNIQUE(FILTER('Credit Pulls'!$E$2:$E$150000,('Credit Pulls'!$D$2:$D$150000=Summary!M17)*('Credit Pulls'!$AI$2:$AI$150000 >0))))

Can someone tell me what I am doing wrong?
Column AI has a 0 or 1, I do not want to include any results that have a 0

 

[Fluff]

There is nor reason why that formula won't work.
Can you post some sample data showing the problem.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[mecerrato]

There is nor reason why that formula won't work.
Can you post some sample data showing the problem.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

Ok thanks, but I thought it was an easy fix, not sure if it is worth going through the "XL2BB" process.

 

[Fluff]

There is nothing to "fix" as there is no problem with the formula you posted. Did you copy paste the formula from your sheet or type it out again?