Thread: function to only show unique cells in range (e.g. B2:B20)
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default function to only show unique cells in range (e.g. B2:B20)
Hi,

You can use Data Advanced filters as well. Very well explained in the
Help menu

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"OnTheEdge" wrote in message
...
I'm trying to figure out how I can automatically only show unique values
in a
column range using a function. Is there a way to do this?

Thanks...

Reply With QuoteReply With Quote