Using MatchIndex on Multiple results to return value for the first result

[Lres81715]

I have a project where 60K records from the original worksheet have duplicate client # numbers. As in, the client placed multiple orders using the same client project key but we supplied different transaction ID's.

The client has asked for report showing the difference in MARKET price, difference in time it took to complete the order, did the transaction have different employees working on it (as in some employees searched the market price for a better deal for the client).
I need a basic formula to help me process each of these requests. A single formula that I can adapt it to meet the needs of each request. I know what needs to be done, just don't know how to start

Example

Client #	Transaction #	Employee #	Transaction Value	Time to complete order
350	5000819117	130797	128000	12
350	5000806127	130797	132000	15
407	5000870212	117615	36000	43
407	5000839178	117615	46000	17
441	5000869157	132204	295000	6
441	5000826105	132204	305,000	7
459	5000896841	131101	195,000	7
459	5000894834	131101	195000	12
641	5000893493	114280	265000	32
641	5000858570	132347	175,000	24

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

3732	5000894416	115281		5
3732	5000853163	115281	260000	9
3732	5000815212	115281	250000	23

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

So for Client #350, employee was the same [True], Transaction Value was [-4000], Transaction % was [3%], Time to complete difference was [-3], TTC percentage was [-25%]

Special note, The client # can be 2, 3, 4, 5 times. So the information should appear on all ROWS but the MIN Transaction ID. So in the case of Client # 3732, the information should appear on Transaction # 5000894416 AND 5000853163 but 50815212 would remain blank.
So it would look like this

Client #	Transaction #	Employee #	Transaction Value	Time to complete order	Same Employee?	Trans Value Difference	Percentage	Time to Complete Diff	TTC Percentage
3732	5000894416	115281		5	TRUE	-260000	#DIV/0!	-4	-80%
3732	5000853163	115281	260000	9	TRUE	10000	4%	-14	-156%
3732	5000815212	115281	250000	23

<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

I've included a partial sheet to try the formula on.

https://app.box.com/s/tinglvb91u2dlristrsamrbzzw8vr8ji

 

[LittleExcel]

Take Same Employee as an example:

Try the formula below for a cell at row 13 under Same Employee column:

=IFERROR(IF(INDEX(C14:$C$60000,MATCH(A13,A14:$A$60000,0))=C13,TRUE,FALSE),"")

The idea is to find the next entry with the same client ID (from Row 14 to end of your total entries)

 

[Lres81715]

Take Same Employee as an example:

Try the formula below for a cell at row 13 under Same Employee column:

=IFERROR(IF(INDEX(C14:$C$60000,MATCH(A13,A14:$A$60000,0))=C13,TRUE,FALSE),"")

The idea is to find the next entry with the same client ID (from Row 14 to end of your total entries)

Hmmm, let me try this and get back to you. This might just work for all instances. Thanks in advance!

 

[Lres81715]

Thanks Little Excel!
This ended up working like a charm. I just modified it for each column I needed. Sum instead of If, Average, CountIf and SumIf all worked perfectly.