I am trying to use the MATCH function to identify the relative position of a value within in a range (a single row of multiple columns). The problem is, the range is unsorted and has zero values and consequently the function returns an #N/A error. Is there a better function to use or a workaround?
Thanks.
Thanks.