Hello.
I am attempting to put together a basic spreadsheet documenting investments and dividend returns.
Looking at the attachment:
I would like a formula that will look in column 'I' for a value greater than zero (0) and, when it finds one, enter the date that is entered in the same row in column 'A' in cell 'L8'. Similarly, the value of the dividend would appear in cell 'M8'. This would continue for all of the values in column 'I'.
By doing this, I would create a separate table (currently highlighted yellow and green) that would show a concise list of all dividend payments and their payment dates.
I hope this is clear, please do ask any questions that may help to clarify.
Thank you so very much for your assistance.
Mark
Screenshot 2019-07-27 at 16.58.21.png
Bookmarks