Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =INDEX('111'!A$2:A$10, AGGREGATE(15, 6, ROW($1:$9)/(('111'!D$2:D$10>EOMONTH(TODAY(), 2))*('111'!D$2:D$10<>"")), ROW(1:1)))&
- ":"&
- INDEX('181'!A$2:A$10, AGGREGATE(15, 6, ROW($1:$9)/(('181'!D$2:D$10>EOMONTH(TODAY(), 2))*('181'!D$2:D$10<>"")), ROW(1:1)))
Add Comment
Please, Sign In to add comment