Rob,
What you've said you want to do with the data would appear to require
a lot of sorting and manual summing/ counting of records per date and
per week, etc.
Not knowing what other data is contained for each record also
presents a problem since there may be formulae involved for
calculations by record and you would have to 'value' this out before
sorting. (ie. make a copy of the whole worksheet for sorting first).
A lot or work in Excel, however, probably can be done given the time.
Have you thought of exporting or importing the data into Access and
doing what you want with a proper database program?
Roy
At 01:02 PM 10/14/2005, Rob Sharp wrote:
Evening all,
I'm hoping someone here is fluent enough in Excel to help with with
a document.
I have a worksheet with around 10,000 rows. One of the columns is a Date.
What I'd like to do is to product a chart that highlights how often
each date appears. Ideally I'd first like to group the dates into
Weeks, sum the number of records per week and then create a records
per week chart, but a records-per-day chart would be fine also.
It sounded fairly simple to me, but Excel 2003 has me beaten.
Does anyone have any pointers?
--
----------------------------------------
To unsubscribe, mailto: [EMAIL PROTECTED]
Is your picture included in the Official Win-Home List Members Profiles Page?
http://www.besteffort.com/winhome/Profiles.html
If not, write to: [EMAIL PROTECTED]
--
----------------------------------------
To unsubscribe, mailto: [EMAIL PROTECTED]
Is your picture included in the Official Win-Home List Members Profiles Page?
http://www.besteffort.com/winhome/Profiles.html
If not, write to: [EMAIL PROTECTED]
