This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a database of people with unique distinctions in a separate column. I'm looking to create a new column for the sum of people by distinction (i.e. Column C would be total headcount of people with distinction x, Column D total headcount with distinction Y, etc.).
What formula should I be using in the formula tool (one for each new column)? The count formula counts the words, but I essentially just need to count the number of rows.
If I'm understanding correctly, by unique distinctions you mean that each person only has a single distinction. In this case, you could do a GroupBy on Distinction, then count on a unique identifier or something. From there, you'll have each row being a distinction, with a column for name and a column for the count. You could convert this to the format you specified using the cross-tab tool.