Problem using Match on columns of numbers with leading zeroesformatted as text ???
=counta(a:a)
will count the number of entries in column A.
=count(a:a)
will count the number of numbers in column A.
I would want these to evaluate to be the same (all entries are numbers) or have
=count() return 0--all entries are text.
For any one particular cell, you can use:
=isnumber(a1)
or even
=count(a1)
u473 wrote:
I am in total agreement with you that the data has to be the same in
content and format to find a match.
And if not, a clean up is required. I have been through that before.
My first run with text ran fine. My second run with numbers and
leading zeroes, formatted as text, fails.
I am still searching,
What kind of test can I run on each workbook to clue me that the cells
have different content or format ?
Thank you for your advice.
J.P.
--
Dave Peterson
|