Hi Domenic,
Unfortunately i keep getting"the formula you typed contains an error)

The column with the 5 greatest and smallest data is AF and i'm trying
to get the result in AE

hence i changed your formula to:
=IF(N(AF3),INDEX($O$3:$O$1007,MATCH(AF3,$P$3:$P$10
07,0)),"")

do i need to make any other changes? and excuse me for my ignorance but
would the MATCH part possible be MATCH(AF3,$O$3:$)$1007,0)),"")

thanks for your help


---
Message posted from http://www.ExcelForum.com/