# Trying to extract unique numbers, NEED HELP!

#### proficient

##### Well-known Member
Hi all,

I am using this below formula to get unique (numbers/numbers with alphabets) from a list but every time getting a same issue that the last (number/number with alphabet) either reflect twice or once.

=IF(ROWS(\$W\$6:W6)>=\$B\$4,"",INDEX(\$B\$6:\$B\$3951,SMALL(IF(\$B\$6:\$B\$3951<>"",IF(MATCH(\$B\$6:\$B\$3951,\$B\$6:\$B\$3951,0)=ROW(\$B\$6:\$B\$3951)-ROW(\$B\$6)+1,ROW(\$B\$6:\$B\$3951)-ROW(\$B\$6)+1)),ROWS(\$W\$6:W6))))

For count unique distinct I am using this formula
=SUMPRODUCT((\$D\$21:\$D\$40<>"")/COUNTIF(\$D\$21:\$D\$40,\$D\$21:\$D\$40&""))

### Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Replies
10
Views
914
Replies
15
Views
693
Replies
3
Views
298
Replies
5
Views
422
Replies
5
Views
204

1,196,409
Messages
6,015,106
Members
441,870
Latest member
kojack

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back