| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need script for filtering data
Hey guys, I have a large excel file with over 50,000 item numbers in it. I column A I have the item number. In column E I have the Manufacturer and in column H I have the sale price. What I am trying to figure ou how to do is to filter the duplicate item numbers that have the sam manufacturer, and pick delete the one with the highest price. Fo example, WEV co128 $1.24 wev co128 $2.27 It would leave the lowes price one alone and delete the highest priced one. Is this eve possible to do through excel? Any help is appreciated -- FUZIO ----------------------------------------------------------------------- FUZION's Profile: http://www.excelforum.com/member.php...fo&userid=3051 View this thread: http://www.excelforum.com/showthread.php?threadid=50167 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Download Data in Thai Script | Excel Discussion (Misc queries) | |||
| getting data from excel worksheet in to a script | Excel Discussion (Misc queries) | |||
| VBS script to add xml data to excel | Excel Programming | |||
| Data match using VB script | Excel Programming | |||
| Excel 2000/XP script to Excel97 script | Excel Programming | |||
Threaded Mode
