View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Reeza Reeza is offline
external usenet poster
 
Posts: 34
Default 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.