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?
Ricardo Rosa
In your formula you are returning the text " AZ" which of course does not equat "AZ". Use this formula instead.
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.=IF(P4="","",IF(LEN(M4)=10,MID(M4,6,2),IF(LEN(M4)>10,MID(M4,6,2),"")))
tanks...
i have lost many hours, with this stupid error...
In the end the solution was very simple... thank you very much...
Kind regards
You're Welcome
Take Care
Posting Permissions
Reply With Quote
