Hello. im filtering through company deal data and i am having a hard time coming up with the right formula to sift through this data properly.im trying to filter by deals in progress, by city, by deal structure, and then only count one of the duplicates. The duplicate count is what stumps me, otherwise i could just use the =Countifs function. so how can i add to the function to count only one duplicate while still filtering through the other column requirements?