Forum Discussion

Copper Contributor

Jan 25, 2023

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,...

excel

Excel on Mac

Formulas and Functions

Riny_van_Eekelen
Jan 25, 2023
navy8or Create a pivot table. Names in the row field and count of Names in the data field.

navy8or

Copper Contributor

Jan 25, 2023

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

Platinum Contributor

Jan 25, 2023

navy8or Create a pivot table. Names in the row field and count of Names in the data field.

navy8or
Copper Contributor
Jan 25, 2023
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!