| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
array
I have this formula:
=IF(ROWS($2:2)<=SUM((W$2:W$67<"")/COUNTIF(W$2:W$67,W$2:W$67&"")),INDEX(W$2:W$67,SMAL L(IF(W$2:W$67<"",IF(ROW(W$2:W$67)-MIN(ROW(W$2:W$67))+1=MATCH(W$2:W$67,W$2:W$67,0),RO W(W$2:W$67)-MIN(ROW(W$2:W$67))+1)),ROWS($2:2))),"") It works great in sorting some of my data and removing any duplicate entries. I would like to use it in another project this time without removing the duplicates. I don't have the experience to spot which part of the formula is removing the duplicates. Thanks for the guidance. Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array: Counting multiple values within array | Excel Worksheet Functions | |||
| meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
| combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) | |||
| Use array to return array of values | Excel Worksheet Functions | |||
| Goal Seek On Members of an Array within Array | Excel Worksheet Functions | |||
Threaded Mode
