Vlookup for First / Last ??? 1

[kristal9]

Hi i am hoping someone can help...

I have a system generated spread sheet that is supposed to be a report but it needs some help.

there are many columns... of them and of imporantance are

A: Article
B: Reviewer
C: Reviewer Accept
D: Reviewer Approve

so my data will look something like this:

Article Rvwer Accept Approve
Go Susie 4-Jan 5-Jan
Go Bob 5-Jan 5-Jan
Go Jeff 5-Jan 7-Jan
Stay Jim 4-Jan 4-Jan
Stay Susie 5-Jan 7-Jan


What I need is this:

Article Nbr Rvwer Accept Approve
Go 3 4-Jan 7-Jan
Stay 2 4-Jan 7-Jan

So that ultimately I can capture elapsed time from the first accept to the final approve and summarize the number of reviewers ...

Nbr revwer is easy countif... but how can i get the earliest accept date and the latest approve date all on one row of data so that I can create a unique list and begin to summarize.

Please let me know if that makes sense and if anyone has an easy fix. I am not sure how or if a MIN IF statement could / would work.

 

[Gavona]

A pivot table using Max, Min and Count Functions, also a calculated field could do the elapsed time bit.

Gavin