Recap
no blank cells in either coulmn
based on a cell address of J4 Need the results from a choosen month
to create a unique list of aircraft used in that month

SPB

"T. Valko" wrote:

Are there any empty/blank cells in either the date range or the tail
number
range?

Well?

The answer to that question can either add complexity of eliminate unneeded
complexity!

--
Biff
Microsoft Excel MVP


"Excel 2003 - SPB" wrote in message
...
unique tail numbers by month only, The rest of the report used a cell ref
for
the date
the previous post did not work, thanks for any suggestions.
SPB

"T. Valko" wrote:

It looks like you want to extract unique tail numbers in a certain date
range.

Are there any empty/blank cells in either the date range or the tail
number
range?

The date range of interest, do you want just a specific month or do you
want
the specific month of a specific year?

--
Biff
Microsoft Excel MVP


"Excel 2003 - SPB" wrote in
message
...
Thanks in advance, I can not get my head around the sumproduct

Database seperate sheet "DATA"
C column =date formated as mm/dd/yy
F column = Aircraft No ei, N123AB

I am trying to product a unique list of aircraft used for the month

I have the following but need to add the date element

=IF(SUMPRODUCT((Data!$F$2:Data!$F$3000<"")*1/COUNTIF(Data!$F$2:Data!$F$3000,Data!$F$2:Data!$F$3 000&""))<=COUNTA($V$129:$V129)-1,"",INDEX(Data!$F$2:Data!$F$3000,MATCH(TRUE,ISERR OR(MATCH(Data!$F$2:Data!$F$3000,$V$129:$V129,0)),0 ),1))

The V129 is where I want to start the list I estimate I will need place
ment
for about 10 aircraft max