R
rishi
Hi,I am trying to write the equation which searches in all the rows of dat
above the cell where the equation is written (dynamic ranges) and return th
total interest value for a user for the month for which the date is entered.
Please take a look at the cell E54 in the file below (sorry, have to wait 3
seconds for download link to appear)
http://host.hackerbox.org/download.php?file=e57fb70280248dfb5cd1264ba1414099
It is a bank ledger and hence the lookup should occur on the dynamic range o
all the above rows of data. It is a little complex for me to describe but pleas
take a look at the Cell E54 in the file for more description.
I am hoping a kind, intelligent soul would help with this.
Thank you.
Rishi
above the cell where the equation is written (dynamic ranges) and return th
total interest value for a user for the month for which the date is entered.
Please take a look at the cell E54 in the file below (sorry, have to wait 3
seconds for download link to appear)
http://host.hackerbox.org/download.php?file=e57fb70280248dfb5cd1264ba1414099
It is a bank ledger and hence the lookup should occur on the dynamic range o
all the above rows of data. It is a little complex for me to describe but pleas
take a look at the Cell E54 in the file for more description.
I am hoping a kind, intelligent soul would help with this.
Thank you.
Rishi