WHen I am at the top entry in a column of say 10 cells, which have 5 different values, pressing the alt key and the down arrow will summarise the 5 unique entries wihin that list of 10. The question I have, is this,,,,,, Is there a formula excel can use to generate this same kind of summary of values. SO for example I could have fx = Summary(a1:a245) where the unique values only woudl be returned ( and that might be a list of only 20 values)

Any help appreciated, I am sure tere is something like this out there. (I am using excel 2003)