hi there, I allow me to propose this another possible solution to copy and drag from C2:
I hope it results useful.![]()
=IFERROR(INDEX(SUBSTITUTE(A$2:A$6," NO",""),MATCH(,INDEX(COUNTIF(C$1:C1,SUBSTITUTE(A$2:A$6," NO","")),),)),"")
hi there, I allow me to propose this another possible solution to copy and drag from C2:
I hope it results useful.![]()
=IFERROR(INDEX(SUBSTITUTE(A$2:A$6," NO",""),MATCH(,INDEX(COUNTIF(C$1:C1,SUBSTITUTE(A$2:A$6," NO","")),),)),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks