#VALUE about function Find

  • Thread starter Thread starter hui
  • Start date Start date
good point and I agree that this is totally messed up, but if you go back to
his original question all i did was make sure that he got it in the format he
was trying to enter without having to type it in again
 
Yes, I am also confused by the huge and unsoted date data. I just wanna deal
with it easily as soon as I can with worksheet function. anyway excel is a
strong office assistant. thanks for your suggestion.

hui
 
Yes, I am also confused by the huge and unsoted date data. I just wanna deal
with it easily as soon as I can with worksheet function. anyway excel is a
strong office assistant. thanks for your suggestion.

hui
 
I am not referring to your response Allllen, I am highlighting the points I
made earlier to the OP.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
I am not referring to your response Allllen, I am highlighting the points I
made earlier to the OP.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
BUT WHAT YOU HAVE NOW ACCEPTED AS A SOLUTION IS NONSENSE, IT DOES NOT SORT
ANYTHING.

All you will get is the number 5 for every row with a number.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
BUT WHAT YOU HAVE NOW ACCEPTED AS A SOLUTION IS NONSENSE, IT DOES NOT SORT
ANYTHING.

All you will get is the number 5 for every row with a number.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Back
Top