Related to Rob's Question, using Excel 2003, I am trying to
sort on sub-totals. I have created the sub-totals and set
up the collapsed worksheet, but I need to copy only the
visible values into a new worksheet and then I will be able
to sort on the sub-totals, but I can not seem to find how
to copy the visible values. I am going to send the
worksheet home and try on Office 97 (where I know I did
this about a year ago), but I would like to be able to do
this in Office 2003 as well since that is the tool at work.
Thanks
Roger Helbig
On Fri, 14 Oct 2005 16:32:20 +0100
Rob Sharp <[EMAIL PROTECTED]> 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]
