Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide Duplicates
Most databases have a feature that allows you to hide duplicates in reports
(see below). Is there a way to do this in Excel? STATE CITY ZIP CODE NC Charlotte 28277 (hidden) (hidden) 28273 (hidden) (hidden) 28274 (hidden) Raleigh 28456 (hidden) (hidden) 28678 SC Columbia 29063 -- FBOL |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide Duplicates
Not like you are thinking, sorry. You could use Conditional Formatting (menu
Format | Conditional Formatting on cells starting at the second entry (after you get them sorted). Choose all cells in a column starting at the 2nd row down to the last entry and then use Format | Conditional Formatting and then leave "Cell Value Is" set to that entry, choose "equal to" in the next entry area and finally type =A1 in the last section; where A1 is the address of the cell above the first cell you have selected. Then click the [Format] button and the [Font] tab and set the font color to the same as the background color (most likely white) and then click the OK button. Repeat for the city column also. "FBOL" wrote: Most databases have a feature that allows you to hide duplicates in reports (see below). Is there a way to do this in Excel? STATE CITY ZIP CODE NC Charlotte 28277 (hidden) (hidden) 28273 (hidden) (hidden) 28274 (hidden) Raleigh 28456 (hidden) (hidden) 28678 SC Columbia 29063 -- FBOL |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide Duplicates
If you created a pivot table from your data, with State, City, & Zip Code as
row fields, they would be presented as in your example. Hope this helps, Hutch "FBOL" wrote: Most databases have a feature that allows you to hide duplicates in reports (see below). Is there a way to do this in Excel? STATE CITY ZIP CODE NC Charlotte 28277 (hidden) (hidden) 28273 (hidden) (hidden) 28274 (hidden) Raleigh 28456 (hidden) (hidden) 28678 SC Columbia 29063 -- FBOL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Condensing a list with duplicates to a list with non-duplicates | Excel Worksheet Functions | |||
Duplicates in excel that aren't 100% DUPLICATES ... | Excel Discussion (Misc queries) | |||
Hide Unhide Hide again | New Users to Excel | |||
Hide Duplicates in a Drop Down List | Excel Discussion (Misc queries) | |||
How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) |