Unique formula with conditions on dates question

[uptopjimbo]

Hello,

I'm working on trying to pull a unique set of project IDs from a table that identifies certain aspects of projects such as a "completed" status and whether or not that status is between a certain date range. Unfortunately I keep getting a #CALC error which I assume means that it's trying to look up something that doesn't exist but, don't really know the function all that well.

Here is what I've been using:

=SORT(UNIQUE(FILTER(FILTER(Table3[[Project Number]:[Break Date]],(Table3[Status]="Completed")*(VALUE(Table3[Break Date])<>0)*(VALUE(Table3[Break Date])>(N1-1))*(VALUE(Table3[Break Date])<(N2+1))),{1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1}),FALSE),2)

In this equation Table 3 is the main database where people can input certain aspects of a project. The Break Date is a caculated column in the spreadsheet that calculates the date something in the lab needs to be broken. If it isn't ready to be broken it just returns "". N1 and N2 are just the dates I want to back-check the "completed" status against.

I"m happy to give more information if this isn't clear enough. I can't upload the file either as its for the company.

Thanks all!

 

[uptopjimbo]

So...figured this out. As it turns out the #CALC error basically means what you're looking for doesn't exist. I was looking for something that was "completed" and had a break date between a couple date ranges. There were break dates in the ranges and there were completions, but they were unique to each other - thus the #CALC error.