Mark McInerney
Active Member
- Joined
- Apr 4, 2012
- Messages
- 288
- Office Version
- 365
- Platform
- Windows
Hi All,
I have a range of data a1:a10000.
In this range there are duplicate values, unique values, blanks and zeros. I am looking for a formula that I can copy fill from B1 that will list only unique values, whilst excluding zeros and blanks.
A1 = Book
A2 = Book
A3 =
A4 = 0
A5 = Toy
A6 = Farm
A7 = 0
A8 = Book
A9 = Toy
I want the data that extends from cell B1 to be
B1 = Book
B2 = Toy
B3 = Farm
Is there a formula that I can copy fill to give this result.
Any Help greatly appreciated.
Thanks - Mark.
I have a range of data a1:a10000.
In this range there are duplicate values, unique values, blanks and zeros. I am looking for a formula that I can copy fill from B1 that will list only unique values, whilst excluding zeros and blanks.
A1 = Book
A2 = Book
A3 =
A4 = 0
A5 = Toy
A6 = Farm
A7 = 0
A8 = Book
A9 = Toy
I want the data that extends from cell B1 to be
B1 = Book
B2 = Toy
B3 = Farm
Is there a formula that I can copy fill to give this result.
Any Help greatly appreciated.
Thanks - Mark.