| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reducing a List by Eliminating Entries from Another List
is there anybody out there who can help me with this issue please???
"Ralph" wrote: also, this formula seems to really be bearing down on my ram and that was only for 1000 rows, i need something to handle up to 10,000 rows, etc... if possible, thanks! "Bernd P" wrote: Hello Ralph, Select C1:C1000 and array-enter: =Pstat("count",ISERROR(MATCH(B1:B1000,A1:A1000,0)) ,B1:B1000) Pstat you can find he http://sulprobil.com/html/pstat.html Regards, Bernd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help needed reducing list. | Excel Worksheet Functions | |||
| how to identify unique list of 200 random entries from a list of 3 | Excel Worksheet Functions | |||
| make a list from another list ignoring duplicate entries from orig | Excel Worksheet Functions | |||
| Removing all entries in one list that appear in a different list | Excel Discussion (Misc queries) | |||
| Eliminating blank cells in a list on a ROW | Excel Worksheet Functions | |||
Threaded Mode
