#### Simon Lloyd

##### Administrator

- Joined
- Apr 2, 2011

- Messages
- 401

- Reaction score
- 0

- Points
- 0

- Location
- Manchester, England

- Excel Version(s)
- Excel 2016

Here's a stock formula for display unique values from column A:

Use an Array formula:

{=INDEX($A$2:$A$8,MATCH(0,COUNTIF($B$2:B2,$A$2:$A$8),0))}

Drawbacks?, the committing of the formula requires the 3 simutaneously pressed keystroke, the committed array formula breaks when clicking in to the cell and of course its volatile, all of these are the reasons for my reluctance to give that solution.

What thoughts do you have on this? got any better ways?