| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help. Remove dups automaic of same name,price,month.
I have a spreadsheet called Book1 with 2000 lines.
Where there is a dup in rate , name and month I want to remove the dup lines from the spreadsheet. Keeping just one line. If the price is diff but same month, name and rate i want to keep in the spreadsheet. Please include necessary info to do this. Column A Column B Column C Jan Jane Doe $12 Jan Jane Doe $12 Feb Jane Doe $12 Mar 07 Jane Doe $14 Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help: Need Excel formula to return correct price from price history table | Excel Discussion (Misc queries) | |||
| Remove old month from chart add new/no manual reference change | Charts and Charting in Excel | |||
| calculate/convert volume price to monthly average price | Excel Worksheet Functions | |||
| automaic "nice" display of the labels in a pie chart | Charts and Charting in Excel | |||
| How do I get the average price per bid for an individual month? | Excel Discussion (Misc queries) | |||
Threaded Mode
