Lookup unique values & calculation

[gxrxba]

This is the first time I am using this forum. Any help on this o
pointing me on the what kind of function to use will be greatl
appreciated. Here is the problem in detail. Column A contains compan
names. Column B will have date. Column c will have a code f1, f2, f
till f15. column D & E will have numbers or blanks. Each company nam
will have its own f1, f2 f3 in column c. All codes for differen
companies will have values in 2 columns (D & E)on which I will be doin
calculations. My problem is to find certain code or codes for on
company, based on that, do calculations. The calculation I will b
doing would be : if the value1=value2 for code F6 & value 1<> value
for code F5, then I would do the following for code F5. Calculat
another value1 in another column. which would be F6-(f1+f2+f3+ f4).
don't know how I will be able to write a formula which would achiev
the above for all the companies in the list which runs into 700 rows.
am also attaching a small test file

Attachment filename: test.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=54486

 

[Frank Kabel]

Hi
enter the following formula in G6:
=IF(C6<>"f5","",IF(AND(D6<>E6,D7=E7),D7-SUM(D25),""))
and copy this down

 

[gxrxba]

Thanks Frank for your very prompt reply. I think I spend a whole day
nearly trying to figure it out. Guess I have a long way to go in
mastering excel