HW 2.5 – answers

Here’s how I think a model for Bill’s lemonade stand should look.

And here is how the Pivot Tables should be done.

I’ll leave it for someone else to publish the VBA.

And here’s my view on the Ski Rankings from Z Resort

 

Advertisements

One comment

  1. VBA to Count the Unique Values in the Input Range (it is working!).

    Option Explicit
    Function CountUniqueValues(InputRange As Range) As Long

    Dim cl As Range, UniqueValues As NewCollection

    Application.Volatile
    On Error Resume Next

    For Each cl in InputRange
    UniqueValues.Add cl.Value, CStr(cl.Value)

    Next cl
    On Error Go To 0
    CountUniqueValues =UniqueValues.Count

    End Function

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: