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
VBA to Count the Unique Values in the Input Range (it is working!).
Function CountUniqueValues(InputRange As Range) As Long
Dim cl As Range, UniqueValues As NewCollection
On Error Resume Next
For Each cl in InputRange
UniqueValues.Add cl.Value, CStr(cl.Value)
On Error Go To 0
Fill in your details below or click an icon to log in:
You are commenting using your WordPress.com account. ( Log Out / Change )
You are commenting using your Twitter account. ( Log Out / Change )
You are commenting using your Facebook account. ( Log Out / Change )
You are commenting using your Google+ account. ( Log Out / Change )
Connecting to %s
Notify me of new comments via email.