Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I advance filter a large csv file for unique customer #'s
I have a large csv file that the rows data repeats save for a couple data
elements in each row. I need to reduce the file to conatin each row that is unique (i.e. has the same customer order number) one time and one time only ( i need all the data in that row). I need to make this fileter into a macro that I can run each and everyday to strip out only the unique records i need. I have read the avaiable advance filter information, but cannot get it to work on my file. I prefer to use the copy to another area feature to preserve the original information. Help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advance Filter | Excel Discussion (Misc queries) | |||
Massive large size of Excel File after Updating | Excel Discussion (Misc queries) | |||
Array Functions from Alan Beban | Excel Worksheet Functions | |||
Text manipulaion (summarizing customer records) Index function probably not good choice | Excel Discussion (Misc queries) | |||
Trouble with Filters on a large file | Excel Discussion (Misc queries) |