| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Remove dup names and if same rate.
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 ALL necessary info and steps. 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 | |||
| Remove Names from .xls | Excel Discussion (Misc queries) | |||
| Select from List of names to equal a specific rate | Excel Worksheet Functions | |||
| Real RATE of return using =RATE illusive, inflation adjusted inflo | Excel Worksheet Functions | |||
| APR - Annual Percentage Rate to Actual Interest Rate | Excel Worksheet Functions | |||
| HOW DO I REMOVE DUPLICATED NAMES ON SPREADSHEET EXCEL97 3900 ROWS. | Excel Worksheet Functions | |||
Threaded Mode
