Small Function not working

[kingkong1028]

Hi guys, So I used this function before and it was working fine, however at the moment it is returning all error messages. =IFERROR(SMALL(IF(NameOfRange1 = $AU$28, ROW(NameOfRange1)), ROW(1:1)), "") and then press Shift+Ctrl+Go. Thanks a bunch for your help.

 

[Asala42]

Are you getting a circular reference error or something? Your IFERROR should capture any issue with errors within the referenced data range.

Double check your NameOfRange1 range. It may be invalid or including cells outside the intended range.