How to find the minimum value in a database with multiple values .

G

Guest

I am trying to find the earliest transaction date for a program participant
with multiple records relating to each participant. For example in a list of
transactions participants are identified by their SSN, there are many
transactions by each participant with the date of each transaction recorded.
I want to find the earliest transaction date by each participant without
sorting the database.
 
G

Guest

One way

=MIN(IF(B3:B300="a",A3:A300))

dates in A3:A300 (need to be real excel dates thus numeric), participants in
B3:B300 and the above formula will find the earliest date for participant "a"

needs to be entered with ctrl + shift & enter


Regards,


Peo Sjoblom
 
M

Myrna Larson

Assuming the transaction is list in A2:B500, with SSN's in A and dates in B,
and you create a list of the unique participants in D2:D30, in E2 type this
formula

=MIN(IF($A$2:$A$500=D2,$B$2:$B$500))

You must press CTRL+SHIFT+ENTER to enter this as an array formula. Copy it
down through E30.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a column if two ranges match 4
If Then List Formula? 4
How can I pull data from several worksheets? 7
Find records in one table without relations in another 3
Complex Database - How do I accomplish the Goal? 8
How to setup database to make transactions (transfers) between two bank accounts 0
Create report with EARLIEST date for several different participant 4
DESIGN DATABASE AND MANY TO MANY RALATIONSHIPS 3

Top