Dear Expert,
Go through the excel sheet.
I want to calculate cumulative days invested in investment but selling data and current investment data are in different sheet.
Now formula and answer if i keep it combine i have given in attached sheet and highlited in green color.
I want same formula in yellow highlighted cell if i keep the data in different site... i think its next to impossible but expert pl share your view..
Regards,
Tushar M.
Go through the excel sheet.
I want to calculate cumulative days invested in investment but selling data and current investment data are in different sheet.
Now formula and answer if i keep it combine i have given in attached sheet and highlited in green color.
I want same formula in yellow highlighted cell if i keep the data in different site... i think its next to impossible but expert pl share your view..
Regards,
Tushar M.