iserror and match help matchs and no matchs?
I have a list of students name with ID numbers and also have a list of ID number of student that attend my lectures. currently i use =IF(ISERROR(MATCH(B2,$E$2:$E$17,0)),"",B2) to sort out the matches which works ok. Only porblem is tat it does not show if there are no matches can any one help
The blanks mean no matches found according to your formula.... don't they?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
yes NBVC i think so
so does that answer your question?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks