LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11
Default How to use AUTOFILTER to update FREQUENCY distribution

Thats a couple of good ideas - the data originally comes from a Access
database, in fact it is way over 65,000 records!
I can probably try rounding the floating numbers to 1 decimal place or so
(and/or scale them up to INTs if necessary) and then do it all in a query.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Median for frequency distribution Samirkc Excel Worksheet Functions 5 April 3rd 23 03:44 PM
How can i do a frequency distribution by machine automatically? Steve[_12_] Excel Worksheet Functions 1 August 15th 08 05:08 AM
Frequency distribution steve Excel Worksheet Functions 1 April 10th 08 01:38 PM
Frequency distribution Ms MIS Excel Discussion (Misc queries) 1 April 6th 05 05:07 PM
Sorting - Frequency distribution. Stats guru Excel Discussion (Misc queries) 1 April 4th 05 04:16 AM


All times are GMT +1. The time now is 05:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"