Data validation
- Thread starter Ufoo
- Start date
Ufoo
Please note that it has been detected that this post is Cross-Posted on other Excel Forums
This is considered poor practice when you haven't notified us of the fact.
This is because you may well have received an answer somewhere and yet people here are still trying to solve the problem, where they could be assisting others.
Please ensure that you read the sites rules at:
http://forum.chandoo.org/link-forums/new-users-please-read.17/
Further breaches may result in you loosing access to the site
Please note that it has been detected that this post is Cross-Posted on other Excel Forums
This is considered poor practice when you haven't notified us of the fact.
This is because you may well have received an answer somewhere and yet people here are still trying to solve the problem, where they could be assisting others.
Please ensure that you read the sites rules at:
http://forum.chandoo.org/link-forums/new-users-please-read.17/
Further breaches may result in you loosing access to the site
This is noted @Hui. I apologize. I have written my apology in the other forums as well. I agree it is poor practice, and I have no reason to repeat this. I would kindly ask you to accept my apology and help me to solve my problem.
I think people are sort of angry with me. But I would urge people to forget about this. Please let us move forward
Last edited:
AliGW
Well-Known Member
OK, here's what you've given us:
Would you care to explain how anyone could even begin to work out the data validation rules without knowing what exactly this data means? For instance, what is 'FALSE'? What does that refer to? With such a lack of information, you won't get an answer anywhere you've asked the question, and as we know, that's in so many places that you can't even remember where they all are!
Would you care to explain how anyone could even begin to work out the data validation rules without knowing what exactly this data means? For instance, what is 'FALSE'? What does that refer to? With such a lack of information, you won't get an answer anywhere you've asked the question, and as we know, that's in so many places that you can't even remember where they all are!
@AliGW you are being extremely unfair to me. Please let us put this issue of cross-posting behind us. I have posted my apology. Unless you are not willing to accept my apology. Shall we please? I have not done a crime. I have breached the rules, and for the fourth time I say I AM APOLOGETIC. You reprimanded me in excelguru, and here you are doing the same thing. As if I cross-post all the time. I think it is not fair. Do you ever make mistakes @AliGW?
When I asked in excelguru.ca how to attach an excel sheet, you are the one who told me how to do it. And I attached the sheet. Did you see my response? And if you scroll up here you will see the same sheet.
Not elsewhere. In excelguru.ca. Ri
Yes. =AND(E9="Loan",SUMIFS($F$6:F9,$C$6:C9,C9,$E$6:E9,"Loan")-SUMIFS($F$6:F8,$C$6:C8,C9,$E$6:E8,"Repayment")=F9,F9<3*SUMIFS($F$6:F9,$C$6:C9,C9,$E$6:E9,"Savings")). But it is not working. It is restricting any entry. If you use the formula in data validation you will see what I mean
AliGW
Well-Known Member
You will need to seek clarification from the person who offered the solution. As I have explained, I do not understand what you want or how to achieve it with the data you have given.
I am sorry you feel I have been harsh, and I probably have in a way, so I apologise for that.
I am sorry you feel I have been harsh, and I probably have in a way, so I apologise for that.
Thank you. Let me seek clarification. Have a wonderful day (my time)
Someone (NBVC) in excelguru has solved this puzzle for me. Let me post the formula here for others to learn/ build up on. =IF(E6<>"Loan",TRUE,AND(SUMIFS($F5:F$6,$C5:C$6,C6,$E5:E$6,"Loan")<=SUMIFS($F5:F$6,$C5:C$6,C6,$E5:E$6,"Repayment"),F6<3*SUMIFS($F5:F$6,$C5:C$6,C6,$E5:E$6,"Savings")))