DATE | REGION | LOWER: | 1/14/2016 | |||
1/11/2016 | WEST | UPPER: | 1/20/2016 | |||
1/12/2016 | EAST | unique values | ||||
1/13/2016 | WEST | REGION | ||||
1/14/2016 | NORTH | NORTH | WEST | |||
1/12/2016 | SOUTH | NORTH | WEST | |||
1/16/2016 | NORTH | NORTH | WEST | |||
1/17/2016 | NORTH | EAST | WEST | |||
1/13/2016 | SOUTH | WEST | WEST | |||
1/19/2016 | EAST | WEST | ||||
1/20/2016 | WEST | WEST | ||||
1/16/2016 | NORTH | WEST | ||||
1/22/2016 | SOUTH | |||||
<tbody>
</tbody>
Columns: Dates = A, Region = B, etc..
I want to extract only unique records for dates between D1 and D2
The formula below (under Region in red, gives me all records between the dates:
=IFERROR(INDEX($B$2:$B$13,SMALL(IF($A$2:$A$13>=$D$1,IF($A$2:$A$13<=$D$2,ROW($B$2:$B$13)-ROW($B$2)+1)),ROWS($D$5:D5))),"") there was a slight mistake here A2:A13 not A2:A11 sorry
I want to extract only the unique records but it always gives me the same first one although in formula evaluator i get the right row number!!
=IFERROR(INDEX($B$2:$B$13,IF($A$2:$A$13>=$D$1,IF($A$2:$A$13<=$D$2,SMALL(IF(FREQUENCY(MATCH($B$2:$B$13,$B$2:$B$13,0),ROW($B$2:$B$13)-ROW($B$2)+1),ROW($B$2:$B$13)-ROW($B$2)+1),ROWS($E$5:E5))))),"")
Please can anyone help? I don't know what I am doing wrong
Thank you so much
carlo