Column of elements with out repetition

		Microsoft Office Forums > Microsoft Excel > Excel
Column of elements with out repetition

FAQ

Thread Tools

Display Modes

03-05-2018, 05:52 AM

Leanmarca

Mac OS X

Office 2016 for Mac

Novice

Join Date: Mar 2018

Posts: 4

Column of elements with out repetition

Guys,
I have a column of elements (colours) and i need a formula that can bring back those elements without repetition.
For example if i have
blue
blue
yellow

i need it bring back
blue
yellow

Colours come from a dropdown list

hope you can help.

Thanks

Attached Files

Material order Sample 2.xlsx (40.0 KB, 11 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Searching for any instances of immediate word repetition (eg "the the")	bertietheblue	Word	6	02-05-2018 06:30 PM
Repetition of connection data across multiple database fields	NickLocke	Word	1	10-31-2016 01:51 AM
Drop down Menu and Content Repetition	legal86	Word VBA	1	11-17-2015 09:55 PM
prevent repetition in form	johnbest	Word VBA	2	03-31-2015 11:42 PM
Sorting elements in a row	Riccardo	Excel	2	12-14-2010 10:08 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:50 AM.