• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Need to count the occurences of values in a single Excel column

S

Schrodinger

Golden Member
I have just shy of 1000 rows in an Excel worksheet. Each row is only 1 column wide.

The values range from 0 to 15.

Basically I need to tabulate the occurence of each value.

Thanks 😉
 
counif works kranky, but he would have to do that for each of the 15 values...

an easier way would be a pivot table...

lets say your values are in column A...

In column B, put a 1 in each cell next to every value you have in column A..

Give each column a header name - A might be "value", and B might be "counter" (these might be in cells A1 and B1, respectively).

goto data-pivot table, and choose next until you can choose "layout" - drag the "value" header into the row, and drag the "counter" header into 'data', and make sure it says "count of data"...then hit finish

Your resulting pivot table should show you values 0 through 15, and next to each one the count of how many times they are in that list.

Kranky is still the man though!
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top