Re: Need advice to start off a project - HELP!
From: Scoops (ian.leigh_at_cpbb.co.uk)
Date: 10/07/04
- Next message: JE McGimpsey: "Re: Menu Item "Insert" Disappears and can't retrieve it"
- Previous message: Sharon Toji: "Menu Item "Insert" Disappears and can't retrieve it"
- In reply to: Bob Greenblatt: "Re: Need advice to start off a project - HELP!"
- Next in thread: Bob Greenblatt: "Re: Need advice to start off a project - HELP!"
- Reply: Bob Greenblatt: "Re: Need advice to start off a project - HELP!"
- Messages sorted by: [ date ] [ thread ]
Date: 7 Oct 2004 06:22:12 -0700
> It's hard to visualize exactly what you data looks like without some more
> detail; or to guess accurately about what reports or charts you'd like.
> However, look into filtered lists. It's likely that a simple filter can do
> just what you want. If not, an advanced filter surely can. Check back here
> if you need any more help.
I will try and give a bit more info! The spreadsheet will have house
numbers down one side and across the top a visit type. Dates can then
be input against the house number and the visit type. What I need to
do first is search through a whole range of cells looking for
instances of a specific date (or identifying the first date to come
along and searching for that, then looking for another date on the
next search) and count how many there are to put in a summary sheet at
the bottom. The graphs and so on aren't too important just now I guess
I need to get the basic concept working first.
- Next message: JE McGimpsey: "Re: Menu Item "Insert" Disappears and can't retrieve it"
- Previous message: Sharon Toji: "Menu Item "Insert" Disappears and can't retrieve it"
- In reply to: Bob Greenblatt: "Re: Need advice to start off a project - HELP!"
- Next in thread: Bob Greenblatt: "Re: Need advice to start off a project - HELP!"
- Reply: Bob Greenblatt: "Re: Need advice to start off a project - HELP!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|