| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I REMOVE UNIQUE VALUES IN EXCEL?
Try this:
=IF(ISERR(SMALL(IF(COUNTIF(Rng,Rng)1,ROW(INDIRECT ("1:"&ROWS(Rng)))),ROWS($1:1))),"",INDEX(Rng,SMALL (IF(COUNTIF(Rng,Rng)1,ROW(INDIRECT("1:"&ROWS(Rng) ))),ROWS($1:1)))) ctrl+shift+enter, not just enter copy down as far as needed "andy" wrote: Is there anyway to automatically remove unique entries on excel 07? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to remove duplicates and combine their unique values? | Excel Discussion (Misc queries) | |||
| how to count unique values in excel based on multiple criteria | Excel Worksheet Functions | |||
| Count unique values and create list based on these values | Excel Worksheet Functions | |||
| Extract Unique Values, Then Extract Again to Remove Suffixes | Excel Discussion (Misc queries) | |||
| how to count unique values in excel based on criteria | Excel Worksheet Functions | |||
Threaded Mode
