Delete duplicate Cells (formula)

[Ran]

Is there a formula that will delete duplicate Columns/ and or rows

 

[Ran]

Bumping up--- If it can not be done let me know

 

[Rowan Drummond]

Have a look at Chip Pearson's Duplicates page:

http://www.cpearson.com/excel/duplicat.htm

Hope this helps
Rowan