sumproduct to create a unique list
no blank cells in either columns
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
|