I am trying to use the match formula to find where the answer in the yellow is in the range of cells selected but it doesn't seem to be working. I have this formula before without any problems but it's not working on this occassion. I am sure it is something to do with the brackets but i can't work out how to fix it. Any help?
Thanks.
=match(a4,b6:y6,0)
trouble is with say (1-1) that matches twice @2 and @5
Last edited by martindwilson; 02-20-2009 at 11:16 AM.
easy as that!!
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks