If you re-read the query, think the OP wants col E to be compared with what's
in col M, with the answer placed in col J.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"leerem" wrote:
yes,
if the data to be checked is Text then
enter this into Cell M3 if data to be checked is in cell E3
=IF(ISTEXT(E3)=TRUE,"Y","N")
if Numeric then IF(ISNumber(E3)=TRUE,"Y","N")