• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Count by Area and Date

Hi I know this is very basic, but I'm struggling today.

If anyone can give me a quick formula, to count the number of areas that appear on a date, I would be forever grateful.

I've already removed the duplicates.

Forever Grateful!
 

Attachments

  • Area Count.csv
    14 KB · Views: 5
Kelli Webb
Why csv-file ... ?
Did You test something like next ... without formulas ...
1) Data ... Text to Columns
2) Data ... Pivot-table
 

Attachments

  • Area Count.xlsx
    51.8 KB · Views: 5
Back
Top