Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"list unique" instructions fr xldynamic site doent work
I am trying to use the "list unique" instructions given by xldynamic given in
the following link: http://www.xldynamic.com/source/xld.xlFAQ0021.html Its instructions are as follows: A1:A100 are the input data, and we want to find the unique list of these data B1=IF(COUNTIF($A$1:A1,A1)=1,ROW(A1),"") This givens the row number of unique entries and works fine C1=SMALL(IF($B$1:$B$100="","",ROW($B$1:$B$100)),RO W(B1)) an array formula, and my data it returns 1 for all columns which is strange D1=IF(ISNUMBER(C1),INDEX(A:A,C1),"")) supposed to give the unique list but in my case only gives the first entry in all cells. I think something is wrong in C1 formula. Any comment is welcomed. -- Rasoul Khoshravan Azar Kobe University, Kobe, Japan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I am unable to "print screen" flollowing the instructions in HELP | Excel Discussion (Misc queries) | |||
How to get rid of the MS "Community NewsGroups" Tree on this site? | Excel Discussion (Misc queries) | |||
How to make a living "growth" barometer (will go on a web site)? | Excel Discussion (Misc queries) | |||
pictures to work with "data" "sort" option | Excel Discussion (Misc queries) | |||
"Show Field List" in Pivot Table Toolbar doesn't work | Excel Discussion (Misc queries) |