I have a Excel file (giftcard) i need to return "earliest valid Giftcard nr." in column M.
Column A= "Giftcard no"
Column B= "Customer no"
Column D= "Giftcard valid to date"
A customer can have more then one (ex. customer no 0000208) "Giftcard".
The "Giftcard" is valid if "Valid to"(Column D) is today or later
"Earliest valid giftcard no" need to be shown on all rows. If a "Giftcard" is before today or there is a earlier valid "Giftcard" it need to be shown in column M. So all giftcard with same "Customer no" has same "Ealiest valid giftcard no".
Bookmarks