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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
array
How about
=W2 and copy down? -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "smonsmo" wrote in message ... 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 |
Reply |
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 |