If you're talking about the MATCH function, you can use this.
This is an array function and as such, you'll need to hold CTRL and SHIFT before pressing ENTER![]()
=MATCH(1,--EXACT(A1:A100,"SAND"),0)
If you're talking about the MATCH function, you can use this.
This is an array function and as such, you'll need to hold CTRL and SHIFT before pressing ENTER![]()
=MATCH(1,--EXACT(A1:A100,"SAND"),0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks