Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to create a list of unique dates? | Excel Discussion (Misc queries) | |||
Tough: Vlookup, Match, Sumproduct? To create list of persistence | Excel Discussion (Misc queries) | |||
Count unique values and create list based on these values | Excel Worksheet Functions | |||
create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
Unique sumproduct with criteria! | Excel Worksheet Functions |