| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display all values in other cells with no duplicates
Please see the example below. What would be the formula to display in one
cell, A5 all the values in A1:D2 without any duplicates. Thanks in advance. Example A B C D 1) 1 6 3 7 2) 2 7 6 5 3) 4) 5) 1,2,3,5,6,7 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display formulae instead of showing values in cells | Excel Worksheet Functions | |||
| How do I compare values of two cells and display the lowest. | Excel Worksheet Functions | |||
| display formula instead of its values in some cells | Excel Worksheet Functions | |||
| Display text depending on values of 3 different cells? | Excel Worksheet Functions | |||
| display zero values in selected cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
