Small formula gives #N/A error (solved)

[Im_Offset]

Hello all,

I am beyond frustrated right now, and need help....

I have a named table with over 26,000 rows in it. In one of the columns, I have a nested if formula that returns a "" or a number. It works just fine.

Now, I am trying to make a list of the rows that have a number in it from the smallest to the largest number. I am using the small function. My formula reads as follows:
=small(table_name[column_name],row(a1))

It returns #N/A and I do not know why!?!?!?!? I have an almost identical spreadsheet that I used last year, and this formula worked with no issues. But now I am banging my head against the wall.

Can anyone help explain to me why I am getting that error and how I can fix it?

Thank you in advance and I continue to be:
Offset

 

[AliGW]

Can you attach a sample workbook?

 

[p45cal]

Seems OK here. Yes, need sample workbook.

 

[Im_Offset]

Thank you for the replies... I figured out the problem! There were 5 rows in the column of my nested if formula that had an error as a result, and that was keeping the small function from working. Wow... I apologize for making y'all work on my "problem" but for the longest time, this had me stumped.

Thanks anyways