sameer bhide
New Member
[pre]
[/pre]
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
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