Remove Duplicates but keep Cell Spacing

Hi there,

Apologies if this seems like a simple query, but it's been driving me mad!

I have a list of events, sorted by date, then location, with descriptions. I only want to show the date the first time it happens.

I have found the Remove Duplicates button, but that shifts all cells upwards. I'd rather select duplicate cells and clear contents, then it would keep the blank cells between the dates.

Is this possible?

Many thanks for your time,

Emma

Hey Jeffrey,

That's a great suggestion, thanks, but I think it may be unsuitable based on what I'll then do with the data.

I convert it to xml and then import it into inDesign to produce a listings section of a magazine, so even in a different format, once it was converted to xml, the data would show again.

I'd love it if anyone else had any other suggestions?

Thanks,

Emma

Originally Posted by :) Sixthsense :)

Make use of COUNTIF or COUNTIFS functions

Thanks for the suggestion Sixthsense.

Unfortunately, I'm not very experienced with Excel - could you possibly explain further?

Thanks,

Emma