View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Legend Legend is offline
external usenet poster
 
Posts: 7
Default Duplicate Values

If I have the following data:

1
1
1
2
2
2
3
3
3
1
1
1
2
2
2

How will I get the following output?

1
2
3
1
2

instead of what excel is giving me?

1
2
3

Someone please advice...