| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
deleting duplicated cells in a list via advanced autofilter?
I have a list which I would like to filter and deleted duplicated records. A1: A250= account numbers B1:""= values C1:"" = loan balances D1:"" = notes I'd like to be able to delete the duplicate account numbers but still show the value, loan balances, and notes that belong to the accounts. Can anyone help. Thanks. Pete:) -- petevang ------------------------------------------------------------------------ petevang's Profile: http://www.excelforum.com/member.php...o&userid=25034 View this thread: http://www.excelforum.com/showthread...hreadid=491461 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
deleting duplicated cells in a list via advanced autofilter?
Oooh. I wouldn't delete that info. It could make life easier when you're doing
other stuff (autofilter/charts/pivottables). But you could hide the duplicates so that it looks like they're not the http://www.contextures.com/xlCondFor...html#Duplicate petevang wrote: I have a list which I would like to filter and deleted duplicated records. A1: A250= account numbers B1:""= values C1:"" = loan balances D1:"" = notes I'd like to be able to delete the duplicate account numbers but still show the value, loan balances, and notes that belong to the accounts. Can anyone help. Thanks. Pete:) -- petevang ------------------------------------------------------------------------ petevang's Profile: http://www.excelforum.com/member.php...o&userid=25034 View this thread: http://www.excelforum.com/showthread...hreadid=491461 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting Cells Option doesn't appear | Excel Discussion (Misc queries) | |||
| importing list with commas from WORD, to individual .xls cells? | Excel Discussion (Misc queries) | |||
| automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
| Data Validation List Option Affecting Other Cells? | Excel Worksheet Functions | |||
Hybrid Mode
