Q
qiong
Hi,
I have a master list of raw stock returns where rows are individual
companies and columns are months (as in jan 73, feb 7, mar 73...). I
need to extract out at the start of each month, according to a certain
criteria, the monthly returns (on the master list) for the next few
years.
So, I created separate worksheets at the start of each month and used
the VLOOKUP function to extract the returns (from the master list) for
the first month. And then used the data table function to find the
monthly returns for the next few years.
My problem is:
In my master list, some companies are 'dead' after some time. So, the
cells are blank. I realised the data tables (on the separate
worksheets) returned a "0" for these cells.
But, I would like to differentiate between these and those returns that
are truly 0 and not belonging to delisted companies.
Is there any way I can get the data tables to return a blank value
instead of "0", like say "IFBLANK... then return blank" or something
like that?
Sorrie for the long message. This is really driving me crazy. Thanks in
advance!
Regards
Keng
I have a master list of raw stock returns where rows are individual
companies and columns are months (as in jan 73, feb 7, mar 73...). I
need to extract out at the start of each month, according to a certain
criteria, the monthly returns (on the master list) for the next few
years.
So, I created separate worksheets at the start of each month and used
the VLOOKUP function to extract the returns (from the master list) for
the first month. And then used the data table function to find the
monthly returns for the next few years.
My problem is:
In my master list, some companies are 'dead' after some time. So, the
cells are blank. I realised the data tables (on the separate
worksheets) returned a "0" for these cells.
But, I would like to differentiate between these and those returns that
are truly 0 and not belonging to delisted companies.
Is there any way I can get the data tables to return a blank value
instead of "0", like say "IFBLANK... then return blank" or something
like that?
Sorrie for the long message. This is really driving me crazy. Thanks in
advance!
Regards
Keng