0:00
today I'm going to show you how to count
0:02
count how many times a particular
0:04
account number comes up in this list so
0:06
I'm going to use the count if function
0:09
so I'm going to type equals and count if
0:12
the range we want is this whole range of
0:15
numbers if we hit control shift and down
0:18
we can get the full list click and type
0:23
comma and our argument or the criteria
0:25
we're looking for is well let's look for
0:27
the first one and then if we C close the
0:30
bracket and hit enter so this number
0:34
appears 16 times this range absolute by
0:37
selecting it and hit an F4 so that means
0:40
uh as we drag down or we double click
0:43
the range that we're looking at always
0:45
Remains the Same so we can see that this
0:48
count number appears 16 times this one
0:50
actually only appears once and you can
0:52
see that the most frequent account
0:54
number there is this one at 430 times