counting

Asala42 · May 20th, 2002, 11:44 AM

Hey,

Have you considered using a Pivot Table- generally they're fairly quick and easy.

Adam

LoungeLizard · May 20th, 2002, 12:26 PM

Quote:

On 2002-05-20 10:44, Asala42 wrote:
Hey,

Have you considered using a Pivot Table- generally they're fairly quick and easy.

Adam

Hi,
I tried using a pivot table but I just get a sum of the entries I need a count of how often numbers occur.

Asala42 · May 20th, 2002, 12:35 PM

Hey again,

You can change the sum to a count directly. Go back to the Pivot table wizard (in the layout section). I take it you have a variable there named "sum of blah" (replace "blah" with your actual variable name). If you double click on that button you'll get a menu with several options, select COUNT instead of SUM.

Adam

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 20th, 2002, 11:44 AM	#1
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,027	Hey, Have you considered using a Pivot Table- generally they're fairly quick and easy. Adam

May 20th, 2002, 12:35 PM	#3
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,027	Hey again, You can change the sum to a count directly. Go back to the Pivot table wizard (in the layout section). I take it you have a variable there named "sum of blah" (replace "blah" with your actual variable name). If you double click on that button you'll get a menu with several options, select COUNT instead of SUM. Adam