Macro to Count Unique Values

[spyldbrat]

I have a spreadsheet that has two sheets. The formula will appear on sheet 1 but I need to show the # of unique values in column b from sheet 2. There is a header on sheet 2 (row 1) so if the count is going to look at the entire column (B:B) then 1 needs to be deducted from the formula. Thanks in advance.

Thank yu a

 

[Fluff]

What version of Excel are you using?
Please update your account details to show this, as it affects what functions you can use.

 

[spyldbrat]

V2008

 

[spyldbrat]

I am sorry, Office 365

 

[Fluff]

Thanks for that.
Do you need this to be a macro, you can just use

=ROWS(UNIQUE(Sheet2!B2:B10000))

 

[spyldbrat]

Nope...works perfectly!!!

Thank you!!!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[MuchToLearn]

I'm not using Office 365, so don't have the UNIQUE function, what's the most efficient way for other versions of Excel?

 

[Fluff]

That depends on your data and your version of Excel.
However please start a thread of your own, rather than "hijacking" somebody else's.