| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
List cell content without duplication or blanks
Hello, looking for some help with the following:-
I have a list of names within Column A, some of which are repeated numerous times. What i require, is to list in Column B each of the names shown in Column A (once only), so those names that are repeated, are only displayed once. Col A Col B A A B B C C B D D E E F A A F |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation List content controlled from cell | Excel Worksheet Functions | |||
| Eliminate List Duplication | Excel Discussion (Misc queries) | |||
| List out the Duplication data in another worksheet | Excel Discussion (Misc queries) | |||
| Remove Duplication from Validation List? | Excel Discussion (Misc queries) | |||
| display a drop-down list based on the content of another cell | Excel Discussion (Misc queries) | |||
Threaded Mode
