Hello again,
Tried to use the last solution to figure this out, but this is becoming one of my new favorite pages!
I have three columns (listed below), I need to count the unique Locations by the designation (IE: the 11-01 designation with 2 Hawaii locations, would be counted once). I need to group this for 3 locations (count the location for Hawaii, San Diego, and Yokosuka to include blanks in the designation) and then checked against today's date (want to list all prior to today's date)
Based on this list the answer should be: 2
Location Designation Start Date
Hawaii 11-01 18-Oct-10
Hawaii 11-01 18-Oct-10
Norfolk 11-01 18-Oct-10
Hawaii 11-01 18-Oct-10
Norfolk 11-02 29-Nov-10
Norfolk 11-02 29-Nov-10
Mayport 11-02 29-Nov-10
Yokosuka 14-Feb-11
Norfolk 11-03 4-Apr-11
Thanks!
Bookmarks