| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to blank out cells with duplicate values?
Okay - after an hour on trying to work on what I thought was an easy
task 0 I must ask for help! My column A is a list of order numbers, each order is separated by a blank row... ex: 1234 1234 1234 1234 4321 4321 4321 6789 6789 What I would like to do is delete the duplicate order numbers, without affecting the rest of the row. I thought this might be a simple if statement, but no. Any ideas? Thanks in advance - Bleu |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Imported Data creates blank cells that aren't really blank | Excel Worksheet Functions | |||
| Blank Rows from Merged Cells in Drop Down Menu | Excel Discussion (Misc queries) | |||
| Macro to hide blank cells in a range | Excel Discussion (Misc queries) | |||
| enter numbers in blank cells | Excel Worksheet Functions | |||
| Function to list values of last 3 non-blank cells in a vertical bl | Excel Worksheet Functions | |||
Threaded Mode
