Repeating Text / Cells

[abmoser]

Many, many years ago (more than I want to admit), I seem to recall there was a function or button in Excel specifically for the purposes of formatting or report presentation that would simplify the process of removing the text within a cell WHEN IT WAS A REPEAT of the cell above it.

Over the years I have tried to find it many times and cannot. If memory serves me correctly (and at my age that's a big IF!!, can anyone help me find it.

If not, I know there are ways to do this and would appreciate any help possible. I have attached sample files showing current data, a desired result and the perfect result.

Thanks ALL.
Brad

 

[Khalid NGO]

Hi Brad,
Welcome to the forum Chandoo.org...

I think you are in need of unique values:
1) You can select your range, go to Data > Remove Duplicates

2) And formula (suppose in E2) with CSE:
=IFERROR(INDEX($A$2:$A$100,MATCH(0,COUNTIF($E$1:E1,$A$2:$A$100),0)),"")

With current PDF doc, it is difficult to guess the range, where to put result and exact output.

Can you confirm this? or i misunderstood?

Regards,

 

[shrivallabha]

If Brad's confessions are anything to go by then chances are he used "Advanced Filter" rather than remove duplicates (which came with Excel 2007).