Forum Discussion
Solved
Finding FREQ in a dataset
Have some datasets with names associated to different addresses. Some are 1-to-1 others are 1-to-many. For example, John Smith owns several different properties and is listed as the owner for each, while Sally Jones only owns one. I do not have a baseline list of individual powner names, so have not been able to use the standard FREQ function. How can I determine frequency of names without manually counting?
- Hello @navy8or
How about the COUNTIF? =COUNTIF(Range,Criteria)
COUNTIF needs a range (where the names are) and a CRITERIA the name you are looking for. This will give you how many names of each you have. Then you can use the SUMIF... check it out.
Hope this helps!Thanks WassimN -
I considered that, but it still requires creating a CRITERIA dataset - in this case a foundational list of individual owner names. The datasets are too large to manually pull out that initial CRITERIA list.
I guess my struggle is having a dataset that I can visually see have multiple names and I want to see how many of each (the associations with specific properties is not a part of the challenge)
