can I ask now many mondays or tuesdays occur in my data?
On Apr 30, 1:26*pm, tdiv wrote:
In my data set, I have what I refer to as nominal data like day of the week,
location, etc. *I want to know if in xcel I can sort these items and
determine how many I have of each..like how many mondays, how often does a
location occur... can someone point me in teh right direction for information?
Pivot Table!
Assuming you have a list of data, create a pivot table based on the
data and count on a column you're interested in. Tons of examples out
there, no formulas and fast.
|