close
I have review a proceedure written by Ashish Mathur but I can not get it to
work. It continues to return a blank cell. Even when I copy the exact
information the the example he gives. I have written the equation but I am
having difficulty in determining where to mark the arrays
The equation looks like this
=IF(ISERROR(INDEX(N8:O411,SMALL(IF(N8:N411=N415,RO W(N8:N411)),ROW(1:1)),2)),quot;quot;,INDEX(N8:O411,SMALL(I F(N8:N411=N415,ROW(N8:N411)),ROW(1:1)),2))--
JW
全站熱搜