#### jeffreyweir

##### Active Member

**strings as an array**

**Challenge Description**

Good evening, Gentlemen. Your mission, should you choose to accept it, is to:

- Write three formula that respectively return the distinct, duplicate, and unique values of a

jeffreyweir

Haseeb A

Colin Legg[/code][/pre]Good evening, Gentlemen. Your mission, should you choose to accept it, is to:

- Write three formula that respectively return the distinct, duplicate, and unique values of a

**string array.**

- The output of each formula must be an array that can be used directly by other formula (such as CountA etc). That is, we're after a single formula that you can directly incorporate into other formulas - not a formula that has to be entered over a worksheet range in order to work.

- Each formula must return an array of the exact size containing only the distinct, duplicate, and unique values. So as per the sample data and output below:

* The array produced by the Distinct formula will be exactly 11 elements long

* The array produced by the Unique formula will be exactly 8 elements long

* The array produced by the Duplicate formula will be exactly 3 elements long

- Each formula should be completely dynamic, and able to be used on a 1D array of any size.

This message will self-destruct in 10 seconds.

Good Luck

[pre]
[/pre]

Duplicates- The output of each formula must be an array that can be used directly by other formula (such as CountA etc). That is, we're after a single formula that you can directly incorporate into other formulas - not a formula that has to be entered over a worksheet range in order to work.

- Each formula must return an array of the exact size containing only the distinct, duplicate, and unique values. So as per the sample data and output below:

* The array produced by the Distinct formula will be exactly 11 elements long

* The array produced by the Unique formula will be exactly 8 elements long

* The array produced by the Duplicate formula will be exactly 3 elements long

- Each formula should be completely dynamic, and able to be used on a 1D array of any size.

This message will self-destruct in 10 seconds.

Good Luck

**Sample Data**

(List of people who have so far posted comments in these Formula Challenges)

Names(List of people who have so far posted comments in these Formula Challenges)

Names

[pre]

Code:

```
jeffreyweir
bobhc
Haseeb A
NARAYANK991
Colin Legg
Colin Legg
Shaun
Hui
Haseeb A
Luke M
Sam Mathai Chacko
Haseeb A
shrivallabha
SirJB7
jeffreyweir
Distinct[/b]
[pre][code]jeffreyweir
bobhc
Haseeb A
NARAYANK991
Colin Legg
Shaun
Hui
Luke M
Sam Mathai Chacko
shrivallabha
SirJB7
Unique[/b]
bobhc
NARAYANK991
Shaun
Hui
Luke M
Sam Mathai Chacko
shrivallabha
SirJB7
```

Duplicates

jeffreyweir

Haseeb A

Colin Legg[/code][/pre]