Find project start and end dates in a DB with many different proje

[Guest]

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!

 

[JulieD]

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(D1100="Job 1",B1:B100,""))
to find the end date/ time of a Job No
=MAX(IF(D1100="Job 1",B1:B100,""))

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

Cheers
JulieD

 

[Guest]

Perfect! Thanks so much!!!

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(D1100="Job 1",B1:B100,""))
to find the end date/ time of a Job No
=MAX(IF(D1100="Job 1",B1:B100,""))

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

Cheers
JulieD

 

[JulieD]

you're welcome and thanks for the feedback

Perfect! Thanks so much!!!