I have a CF formular
Is there something that can be added or change to that if text is entred into coloum 'O' then it stays as it is?![]()
Please Login or Register to view this content.
If you need clarification on anything please let me know!
I have a CF formular
Is there something that can be added or change to that if text is entred into coloum 'O' then it stays as it is?![]()
Please Login or Register to view this content.
If you need clarification on anything please let me know!
Last edited by snoopy1461; 12-08-2011 at 10:26 AM. Reason: Solved
Try:
=AND($O5="",AND(COUNTA($B5:$C5=2),$J5<>"",OR(COUNTA($D5:$F5)=3,COUNTA($G5:$I5)=3)))
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
This has worked, thanks for your help
You're welcome. Thanks for the rep.
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks