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
1	3	4
2	5	list
3	5	1
4	2	2
5	2	3
6	1	5
7	3

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</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.