Hide Duplicate Values in an EXCEL Column

[RangerFan]

I am using a simple formula to keep a running total in a column. Presently, the data is displaced as follows:

$150,000.00
$123,000.00
$121,000.00
$121,000.00
$121,000.00
$121,000.00

I would like to hide the duplicate values in this column. In other words, eliminate the last three references to $121,000.00.

I know there is a report feature in Acces that hides dups and was wondering if this is possible in Excel.

Any help will be greatly appreciated.

 

[SkipVought]

Hi,

Use Format > Conditional Formatting ro shade the font the same as the cell interior shade. Asuming that your list is in colunn A starting in A2, select from A2 down thru all rows of data, Format > CF...
[tt]
Formula Is: =A1=A2
[/tt]
and set the format of the font.

Skip,
[sub]
[red][/red]
[/sub]

 

[Rofeu]

You might be able to 'blank them out' with conditional formatting.

You could also use advanced filter, MS Query or a pivottable to get new list with only unique values.

Actually HIDING the duplicates, you will need VBA.

Do a search on this forum and

http://www.tek-tips.com/threadminder.cfm?pid=707.

There have been numerous posts dealing with this very issue.

Cheers,

Roel