#### sameer bhide

##### New Member

Code:

```
Client Amt
IBM 49
TYCO 46
E&Y 82
ORACLE 88
TVS 24
BHEL 79
ABB 29
ORACLE 89
CGL 95
AREVA 49
ABB 63
E&Y 58
IBM 61
AREVA 81
ORACLE 13
ORACLE 100
TYCO 89
CGL 22
SIEMENS 10
ACES 21
AREVA 29
TVS 78
ACES 86
SIEMENS 45
TVS 16
BHEL 69
BHEL 43
IBM 56
ABB 56
```

Column A contains Clients in Random order

Column B Contains Amounts in Random order

Cell D1 contains the name of one Client Eg Oracle

Cell E1 should have a formula that finds out difference in amount between last instance of the searched Client first instance

In our case Last instance of Oracle = 100

First Instance of Oracle = 88

So Difference = 12

For IBM = 56-49 =7

Rules

No Names, Helper Rows and Columns, VBA, No Modification of Data in any manner

My Formula has 62 Characters including the =

Sam