Need Small or large numbers without duplicates.

[Kamran01]

Dear Experts,

I have multiple rows with dates, mostly with duplicates results.
Suppose there are 7 entries of 3-11-2018.

When i use these functions =Small(range,Rows($A$1:A1)) it shows me 7 entries but i want 1 entry of this date.

Can anyone help me in this regard,

Thanks,
Kamran Noor

 

[Aladin Akyurek]

Book1
	A	B
1	3	4
2	5	list
3	5	1
4	2	2
5	2	3
6	1	5
7	3
Sheet1

In B1 enter:

=SUM((FREQUENCY(A1:A7,A1:A7)>0)+0)

In B3 control+shift+enter, not just enter, and copy down:

=IF(ROWS($1:1)>$B$1,"",MIN(IF(ISNA(MATCH($A$1:$A$7,$B$2:B2,0)),$A$1:$A$7)))

 

[Kamran01]

	A	B
list

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]5[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]3[/TD]

</tbody>

Sheet1​

In B1 enter:

=SUM((FREQUENCY(A1:A7,A1:A7)>0)+0)

In B3 control+shift+enter, not just enter, and copy down:

=IF(ROWS($1:1)>$B$1,"",MIN(IF(ISNA(MATCH($A$1:$A$7,$B$2:B2,0)),$A$1:$A$7)))

Exactly what i want.. Thank you boss. you are genius & i am your big fan.

 

[Aladin Akyurek]

Exactly what i want.. Thank you boss. you are genius & i am your big fan.

You are welcome. Thanks for the kind words.