In row 1 i have either "yes" or "" (nothing). I need a match/small index function to return the positions of all the yes values so i can then transfer the pertinent cells to another sheet using the offset function.
Currently, if i have a "yes" in multiple columns, I can only get the first instance to register.
Thanks in advance!
Bookmarks