Hi all,
I am attempting to create a sheet to dynamically populate based on the entries from a larger database. I tried using index,match etc but it just kept populating all rows and not just the ones I wanted. Please see attached doc...
I will have 'Data!' sheet that will list all of the entries, then I effectively just want to populate the 'Flags!' with just the entries that are overdue. I have manually populated to show how it should look.
I added the helper column E on 'Data!' populating a 1 when something is overdue (todays date is > the due date in column D). But this is surplus to requirements if we can get the functionality without using this extra column.
Obviously I need it to function so that if I say updated so that cell c4 on 'Data!' was changed to todays date 02/08/2020, then it would no longer be over due and would disappear from the flags sheet and the other 2 would be moved up the list.
NB: as an extra aesthetic, I guess I might want the overdue flags to be listed in date order, but I guess I can achieve this by sorting retrospectively (just mentioning incase sorting would compromise any formulae in place).
Thanks id advance!
Bookmarks