This will probably be an easy question for an Excel guru / expert / user better than me.
I have several columns of data with values between 1 and 100. I want to get a single histogram-like result that tells me how many '1’s there are, how many '2’s there are, … how many '100’s there are.
I’d rather not concatenate all of the columns into a single column.
How would I do this? (Perhaps histogram isn’t the correct vehicle for this task?) Getting either numerical results or a chart (or both) would be fine.
It sounds like you want the COUNT IF function. The help file for “Count how often multiple number values occur by using functions” section explains how to use that function for this purpose.
Then you can take the results and put them into a pivot table and/or chart.
where range is the columns of data, and value is the number you’re looking for. You might try creating a row or column of cells with each value from 1 to 100 then linking value in the formula to a cell in the 1 to 100 you just created. You can then drag the formula to count the number of each value.
