LinkBack URL
About LinkBacks
If B is:
abc
ba
bc
ad
SEARCH("a",B1:B4) will search "a" in B1,B2,B3,B4; gives array: {1,2,#value,1}
Ctrl-shift-enter, and display first item (1) only. In fact, there are 4 items in array, if,instead of press CSE, try hit F9 to see items in array.
If B is:
abc
ba
bc
ad
SEARCH("a",B1:B4) will search "a" in B1,B2,B3,B4; gives array: {1,2,#value,1}
Ctrl-shift-enter, and display first item (1) only. In fact, there are 4 items in array, if,instead of press CSE, try hit F9 to see items in array.
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks