View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default List unique Values from different columns: How to...

Or use Pivot Table.
No VBA or formulas required
if your data is numeric.
If it is text, use the method shown.
All automatic, except PT refresh.
http://www.freefilehosting.net/download/3c3e6