Abdullah Kajee wrote:
In large spreadsheets more than 1000 rows, I find that Excel ignores values
below the 1000th row? Am I doing someting wrong or is it a program error.

You might want to consider the ArrayRowFilter1 function in the freely
downloadable file at http://home.pacbell.net/beban

Alan Beban