Excel: COUNTIFS
Large data set? Need to count the number of occurrences of a particular value?
Try opening your file in Excel and use:
=COUNTIFS(rangeStart:rangeEnd, value) This will count how many times a particular value occurs between rangeStart and rangeEnd.
Written by Francis San Juan
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Data
Authors
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#