Can you specify the criteria for A1:A10?
In article ,
xlarch wrote:
hey i'm using the same formula, and would like to search with a wildcard
...can someone help?
eg:
IF(ISERROR(INDEX($A$1:$B$10,SMALL(IF($A$1:$A$10=$A $10,ROW($A$1:$A$10)),ROW(1:1
)),2)),"",INDEX($A$1:$B$10,SMALL(IF($A$1:$A$10=$A$ 10,ROW($A$1:$A$10)),ROW(1:1)
),2))
Now i need to replace (if($a$1:$a$10= ($a$10 (i need to add a wildcard
here..how?,ROW......)
|