LinkBack URL
About LinkBacks
how can i remove duplicates numbers inside the formula?
IF($B$1:$E$1=$I$3,IF($B$2:$E$5<>0,ROW($B$2:$B$5)))---> {2,FALSE,2,FALSE;FALSE,FALSE,3,3;FALSE,FALSE,FALSE,FALSE;FALSE,FALSE,FALSE,5}
i just want extract the 2,3,5... anybody can help with this?
how can i remove duplicates numbers inside the formula?
IF($B$1:$E$1=$I$3,IF($B$2:$E$5<>0,ROW($B$2:$B$5)))---> {2,FALSE,2,FALSE;FALSE,FALSE,3,3;FALSE,FALSE,FALSE,FALSE;FALSE,FALSE,FALSE,5}
i just want extract the 2,3,5... anybody can help with this?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks