My collection of things.

jKafer on the Net

September 5th, 2017 at 2:27 pm

New Favorite thing in Excel – Frequency

I love it when I can learn a new thing in software program.

I have had to do this function many times before, however, I have never run across this option:  “Frequency”.

A B C D
1 Purchased   Colors
2 Green   Green
3 Yellow    
4 Green    
5 Red    

 

=frequency(B2:B10,D2) Results = 2

Counts how many times in B2 thru B10 that match what is in D2 – Awesome.

so, let’s add a little bit to this (I love things that do multiple things at one time (multi-tasking!) )


IF… you wanted to know how many unique items are in a column:

=SUM( — (FREQUENCY(B2:B5,B2:B5)>0))

—   =  Double-unary: A single unary operator (-) coerces true/false values into -1/0. By using the double unary operaor, we coerce the values again to 1/0.

This can be used in place of the countif statement for large sets of data.

-

Comments are closed.


  • Count per Day

    • 22Visitors today:
    • 47Visitors per day:
    • 0Visitors currently online:
  • ScrapBook Software - MyMemoriesSuite
  • Latest Pins on Pinterest

    • These yoga poses can help you counteract your desk slouching.

    • Get this fast and easy tutorial for a baby quilt. It is made with beautiful batik fabrics. #quilting #batiks #diyproject #babyquilt ConnieKresin.com

    • grass green rocksteady quilt

    • A modern geometric quilt perfect for any nursery or home. Versatile enough to be used as a picnic or stroller blanket. It perfectly cosy and warm. Like all of our quilts, it has super soft minke backi More

    • blue ombre baby quilt - a fat quarter friendly pattern!

    • Лоскутная геометрия: Hunter's Star / Звезда охотника

    • kg17 -