Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello,
How can I get by formula, in a column, the list of unique elements in a matrix of x columns x rows. For example: A1: A5 ={1,2,3,4,5} B1: B5 = {0,4,5,1,0} C1: C5 = {5,4,0,4,0} Desired outcomes in E1: E15 = {2,3,"","","","","","","","","","","","",""} Thank you in advance for the help that you will help me. Helena |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Identify & List unique values from a list using functions/formulas | Excel Worksheet Functions | |||
Adding new elements to an existing "list" | Excel Worksheet Functions | |||
Finding duplicated elements in a list | Excel Discussion (Misc queries) | |||
How to format two repeating XML elements w/o getting list of list | Excel Discussion (Misc queries) | |||
Non-unique elements in an array | Excel Discussion (Misc queries) |