Do you still need an answer on this?

This will probably need a coding solution.
Are there only two rows in each set?

"Andrea" wrote:

I am relatively new to excel and need help with creating a formula.
Based on the table below my goal is to take information from column A (or a
range of cells), and return a min from column C and a max from column D.

For code 10060, I need the initials in column B to return when the min in
column C has been located (for each code in column A) and the min amount

For the same code 10060 I need the initials in column B to return when the
max in column D has been located (for each code in column A) and the max
amount

The results for code 10060 should read
10060 cc 113 185


I.e.

A B C D
10060 CC 113 164
TS 156 185
10180 CC 327 275
TS 327 327
11041 CC 79 79
TS 60 106
11042 CC 106 106
TS 122 149
11043 CC 357 357
TS 424 424
13133 PS 50 50
TS 247 248

Thanks,
Andrea