parttime_guy
02-11-2012, 08:16 AM
Hi,
I have a column which has alphanumeric characters...
Task to be done
Find/Search the cell for unique number from a Data range and give results.
Problem
If the cell contains only numbers the MATCH function is working
But... if the cell contains alphanumeric characters the formula shows an error :dunno
Attached is a sample file.
Kindly Help :help : pray2:
Best Regards
I have a column which has alphanumeric characters...
Task to be done
Find/Search the cell for unique number from a Data range and give results.
Problem
If the cell contains only numbers the MATCH function is working
But... if the cell contains alphanumeric characters the formula shows an error :dunno
Attached is a sample file.
Kindly Help :help : pray2:
Best Regards