alt and Down Arrow to get a list

[bennyexcel]

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)

[pike]

Hi bennyexcel
Welcome to the forum
maybe try in
E1="Summary"
then in
E2:
=LOOKUP(REPT("Z",255),CHOOSE({1;2},"",INDEX($A$2:$A$300,MATCH(TRUE,INDEX(ISNA(MATCH($A$2:$A$300,$E$1:$E1,0)),0),0))))

fill down

this will give you a unique list of values

[Marcol]

Assuming your data is in A2 down this formula from daddylonglegs
In B2

Please Login or Register  to view this content.

Drag/Fill Down

This will only work if all values are text values and will not sort the list as your key combination does. Alt+Arrow Down ignores all numeric values.
The list must also be continuous.

Hope this helps

[EDIT]
This is the same as pike suggests, the clarification of its' limits might help