PDA

View Full Version : [SOLVED] Strange format problem !!!



Ricardo Rosa
02-21-2005, 05:14 AM
Hi

I have a formula to find the minimum of a column with 2 conditions... but doesn?t work because, despite the values in the cells be equals, Excel doesn?t recognize them as equal? In the attachment file you can see the problem?
Please Help me?
:banghead:
Ricardo Rosa

Jacob Hilderbrand
02-21-2005, 05:32 AM
In your formula you are returning the text " AZ" which of course does not equat "AZ". Use this formula instead.


=IF(P4="","",IF(LEN(M4)=10,MID(M4,6,2),IF(LEN(M4)>10,MID(M4,6,2),"")))

I'm not sure what you want to return in the last Mid function. If you want more than 2 characters, just change that number.

Ricardo Rosa
02-21-2005, 06:46 AM
tanks...

i have lost many hours, with this stupid error...
In the end the solution was very simple... thank you very much...

Kind regards

Jacob Hilderbrand
02-21-2005, 06:54 AM
You're Welcome :beerchug:

Take Care