A SHARP COOKIE
  • Home
  • Contact
  • Cookie Crumbs
  • OCO Files
  • Home
  • The Adjunct Files

Adventures In Technology

Filter by Unique Values in Excel

1/11/2018

0 Comments

 
Having been lucky enough to be an Excel Trainer for many years, I can't believe I forgot how to do this and had to look it up!

I was tracking how many different times people attended training, but I wanted Excel to tell me how many people were unique and give a count for each person.

It is under Data - Sort and Filter - Advanced.

Then I had it copy the data to another row and only show unique values.  Then I ran a count of the names, and it was done!
0 Comments



Leave a Reply.

    Author

    Teacher, Writer, Editor, Instructional Designer.

    Archives

    June 2021
    May 2021
    April 2021
    September 2020
    November 2019
    February 2018
    January 2018

    Categories

    All
    Access
    Accessibility
    Camtasia
    Canvas
    Design
    Excel
    Google Suite
    Microsoft Office
    Power Point
    Stream
    Technology Tips
    Word
    Zoom

    RSS Feed

Services

Tech Training
Content Writing
Editing
Formatting
Publishing

Company

A Sharp Cookie

Support

Contact
FAQ
Terms of Use
© COPYRIGHT 2015. ALL RIGHTS RESERVED.
  • Home
  • Contact
  • Cookie Crumbs
  • OCO Files
  • Home
  • The Adjunct Files