Hey I'm trying to generate a list of names based on whether the next column is blank or not.
=INDEX(D4:D39,MATCH(ISBLANK(H4:H39),0))
It's giving me N/A or sometimes #NAME?
I've been using Ctrl+Shift+Enter but that doesn't work
D4:D39 list of names
H4:H39 list of dates
So the idea is, if the date is blank, then It'll list the names of the people who haven't inputted a date (and therefore haven't completed it)
I would need it so if a date was later input, their name would be removed from the list.
Thanks in advance,
Joe
Bookmarks