Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a column with 20 rows and I am entering this function
=INDEX(Av$6:Av$25,MATCH(ROW()-1,$ax$6:$ax$25,)) in the first row then I copy down till the 20th row. Why from the 17th row it is giving me #N/A. |