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

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

    • Check out Jenny's new tutorial on the Sweet Blend Quilt!

    • All Roads Quilt Kit | Craftsy. Rainbow quilt kit by Angela Walters. #quilting #rainbowquilt affiliate link

    • In my last blogpost I posted a turorial for the pattern FANTASY (below). Lots of people liked it but also wrote that they thought it was too comlex for them. Today’s new tutorial of the patte…

    • color washing paint technique, wood grain still shows, barn door #paint #barn_door

    • Elven Garden Quilts: Desperate House Wives QAL - Woven Chevron Block Tutorial

    • Quilts for Scrap Lovers: 16 Projects • Start with Simple Squares by Judy Gauthier

    • 826d1c8f088145d5f0854444c6ee38ad

    • Make Life Twirly | by BlueElephantStitches

    • hand quilt

    • Super fun "Come Fly With Me Quilt" from Red Rooster Quilts. Pattern available after the jump.