I've got a spreadsheet containing tracking information for a number of
projects. Each row in the spreadsheet contains the following kinds of
information:

Date Start Time Finish Time Job No. Job Description Task Total Hours Total
Charges

Because I might work on a project at several different times during a day
and over the course of several days, there may be many rows of information
associated with a single project. However, these rows will not be contiguous
because I might work on other projects in between these episodes.

I want to find a way to search this data and find the start and end dates
for each project. What's the most efficient way to do this? I've tried using
DMIN and DMAX, but the need to use separate space on the spreadsheet to
define the search criteria (on two rows!) makes that too cumbersome to use
with a large number of projects. There must be a simple way to do this!!!
Anybody know of one?

Thanks!

Hi

i would use a MIN(IF and MAX(IF array formula

e.g.
to find the start date/time of a Job No
=MIN(IF(D1:D100="Job 1",B1:B100,""))
to find the end date/ time of a Job No
=MAX(IF(D1:D100="Job 1",B1:B100,""))

as these are array formulas you need to enter them with CONTROL & SHIFT &
ENTER not just enter

Cheers
JulieD

"AceWriter01" wrote in message
...
I've got a spreadsheet containing tracking information for a number of
projects. Each row in the spreadsheet contains the following kinds of
information:

Date Start Time Finish Time Job No. Job Description Task Total Hours Total
Charges

Because I might work on a project at several different times during a day
and over the course of several days, there may be many rows of information
associated with a single project. However, these rows will not be
contiguous
because I might work on other projects in between these episodes.

I want to find a way to search this data and find the start and end dates
for each project. What's the most efficient way to do this? I've tried
using
DMIN and DMAX, but the need to use separate space on the spreadsheet to
define the search criteria (on two rows!) makes that too cumbersome to use
with a large number of projects. There must be a simple way to do this!!!
Anybody know of one?

Thanks!

Perfect! Thanks so much!!!



"JulieD" wrote:

Hi

i would use a MIN(IF and MAX(IF array formula

e.g.
to find the start date/time of a Job No
=MIN(IF(D1:D100="Job 1",B1:B100,""))
to find the end date/ time of a Job No
=MAX(IF(D1:D100="Job 1",B1:B100,""))

as these are array formulas you need to enter them with CONTROL & SHIFT &
ENTER not just enter

Cheers
JulieD

"AceWriter01" wrote in message
...
I've got a spreadsheet containing tracking information for a number of
projects. Each row in the spreadsheet contains the following kinds of
information:

Date Start Time Finish Time Job No. Job Description Task Total Hours Total
Charges

Because I might work on a project at several different times during a day
and over the course of several days, there may be many rows of information
associated with a single project. However, these rows will not be
contiguous
because I might work on other projects in between these episodes.

I want to find a way to search this data and find the start and end dates
for each project. What's the most efficient way to do this? I've tried
using
DMIN and DMAX, but the need to use separate space on the spreadsheet to
define the search criteria (on two rows!) makes that too cumbersome to use
with a large number of projects. There must be a simple way to do this!!!
Anybody know of one?

Thanks!

you're welcome and thanks for the feedback


"AceWriter01" wrote in message
...
Perfect! Thanks so much!!!



"JulieD" wrote:

Hi

i would use a MIN(IF and MAX(IF array formula

e.g.
to find the start date/time of a Job No
=MIN(IF(D1:D100="Job 1",B1:B100,""))
to find the end date/ time of a Job No
=MAX(IF(D1:D100="Job 1",B1:B100,""))

as these are array formulas you need to enter them with CONTROL & SHIFT &
ENTER not just enter

Cheers
JulieD

"AceWriter01" wrote in message
...
I've got a spreadsheet containing tracking information for a number of
projects. Each row in the spreadsheet contains the following kinds of
information:

Date Start Time Finish Time Job No. Job Description Task Total Hours
Total
Charges

Because I might work on a project at several different times during a
day
and over the course of several days, there may be many rows of
information
associated with a single project. However, these rows will not be
contiguous
because I might work on other projects in between these episodes.

I want to find a way to search this data and find the start and end
dates
for each project. What's the most efficient way to do this? I've tried
using
DMIN and DMAX, but the need to use separate space on the spreadsheet to
define the search criteria (on two rows!) makes that too cumbersome to
use
with a large number of projects. There must be a simple way to do
this!!!
Anybody know of one?

Thanks!