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,...
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!
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)
- Riny_van_Eekelen - Perfect!! I've been avoiding pivot tables in favor of using what I am compfrotable with and this now makes SOOO much sense. Thnaks much!