Hi SHG,
My data in columns is up to 2080 nos and numerous cell contains individual prime number...
I wish to copy in new cell.. some how my following formula is incorrect ( I use Excel 2007)

=IF(A1={2,3,5,7,11,13,17,19,23,25,27,29,31,37,41,43},A1,"")
THX
Karnik