| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to make duplicate entries blank
I want to make a column that lists "city name" to only show each name once,
then leave a each repeat of the name blank. Is there a formula for this? Thanks |
|
#2
|
|||
|
|||
|
You can use Conditional Formatting to hide the duplicates. There are
instructions he http://www.contextures.com/xlCondFor...html#Duplicate woulfer wrote: I want to make a column that lists "city name" to only show each name once, then leave a each repeat of the name blank. Is there a formula for this? Thanks -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
|
|||
|
|||
|
Perfect!!! Thanks!!!
and that's a great resource you have there. I can see me bookmarking that site. "Debra Dalgleish" wrote: You can use Conditional Formatting to hide the duplicates. There are instructions he http://www.contextures.com/xlCondFor...html#Duplicate woulfer wrote: I want to make a column that lists "city name" to only show each name once, then leave a each repeat of the name blank. Is there a formula for this? Thanks -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#4
|
|||
|
|||
|
ASAP Utilities, an Excel Add-in, has a feature that will delete or hide
duplicate rows...... ......it's available free at www.asap-utilities.com Vaya con Dios, Chuck, CABGx3 "woulfer" wrote in message ... I want to make a column that lists "city name" to only show each name once, then leave a each repeat of the name blank. Is there a formula for this? Thanks |
|
#5
|
|||
|
|||
|
You're welcome! Thanks for letting me know that it helped.
woulfer wrote: Perfect!!! Thanks!!! and that's a great resource you have there. I can see me bookmarking that site. "Debra Dalgleish" wrote: You can use Conditional Formatting to hide the duplicates. There are instructions he http://www.contextures.com/xlCondFor...html#Duplicate woulfer wrote: I want to make a column that lists "city name" to only show each name once, then leave a each repeat of the name blank. Is there a formula for this? Thanks -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to remove duplicate entries in column? | Excel Discussion (Misc queries) | |||
| count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
| Preventing Duplicate Entries in rows | Excel Worksheet Functions | |||
| How do I delete duplicate entries? | Excel Worksheet Functions | |||
| Add numbers for duplicate entries then delete | Excel Worksheet Functions | |||
Linear Mode
