R
rishiyoor
With the following in my sheet...
A B C
1 4
2 5 {=MATCH(5,A2:A2,0)}
3 6 {=MATCH(5,ABS(A2:A2),0)}
B2 returns 1, while B3 returns #N/A. Why?
-Rishi
A B C
1 4
2 5 {=MATCH(5,A2:A2,0)}
3 6 {=MATCH(5,ABS(A2:A2),0)}
B2 returns 1, while B3 returns #N/A. Why?
-Rishi