Excel issue

Closed
Riti - May 19, 2011 at 04:01 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - May 19, 2011 at 07:49 AM
Hello,

There are 3 tables, A, B and c, according to the requirement A = B + C. Need to check the value for B, where B = A - c.
Table A contains product code, tenor, and value
Table B contains product code, tenor, and value (Blank table)
Table C contains product code, tenor, and value
There are product codes and tenors which appear both in A and C but the values cost are different.
Can you tell me a formula from where I can get the calculation for Table B.

Table A
Code Tenor Cost value
BND001 M1 1034
CHF M1 14

Table B
Code Tenor Cost value
BND001 M2 -15
CHF M1 2

2 replies

Hello,
There are 3 tables, A, B and c, according to the requirement A = B + C. Need to check the value for B, where B = A - c.
Table A contains product code, tenor, and value
Table B contains product code, tenor, and value (Blank table)
Table C contains product code, tenor, and value
There are product codes and tenors which appear both in A and C but the values cost are different.
Can you tell me a formula from where I can get the calculation for Table B.
Table A
Code Tenor Cost value
BND001 M1 1034
CHF M1 14
Table B
Code Tenor Cost value
BND001 M2 -15
CHF M1 2

The same data is not present in the same rows but different.
0
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
May 19, 2011 at 07:49 AM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.


Note: your data need not be to be real data but a good representative of how data looks like
0