Validate based on multiple conditions

{ 0 Comments }

By Ashish Mathur · February 20, 2010 · DATA VALIDATION · Leave a comment

Validate a range of cells based on multiple conditions – the exact question can be read from here. You may refer to my solution in the this file.

LinkedIn
Facebook
Twitter
Email

Linkedin0 Facebook0 Email0 Twitter0

← Determine weekday after factoring in user specified holidays

Goal seek multiple cells →

Recommendations from LinkedIn

It was a two day session at Quatrro where Ashish trained people from diverse work profiles about Advanced Excel Techniques. The expertise, he posses regarding his subject matter and the preciseness with which he handled the queries of attendees, is really adorable. He is doing a good job by creating awareness among people about undiscovered excel functions, which can seriously reduce time and efforts for daily excel users. I wish him best of luck for his future…

Gunjan Gupta, ACA

Ashish Mathur is on the of Best Excel Expert that i have come across in my life. I met him once in our Corporate traning session on excel. He truely surprised me by his skills on Excel. His method of explaining the excel techniques was also impressive. The whole batch praised about that excel session. All that i can say that i will always be in touch with you “Ashish Mathur, Sir”

CA.Amandeep Singh Sabharwal

Ashish Mathur is an expert in Excel with amasing knowledge on the subject. HIs conceptual knowledge and the way he provides the excel training shows how in depth he has researched on the subject. Always interested to find the best approach to a problem he shows a “nothing is impossible” attitude. Way to go and thanks a lot for the useful training.

Shruti Gupta

I’ ve been part of the training program that Ashish had conducted at our organisation. I found the sessions to be extremely useful for my day to day work and Ashish was exemplary in the way he conducted these sessions. Very practical, systematic and enforcing, the examples provided were of utmost relevance. I have no hesitation in recommending Ashish’s training programs.

Santosh Kumar Peshkar

I knew excel but after attending the session from Mr. Ashish I was ablt to identify new avenues of using the same function which I was not aware off and tremendous application of the same. It is awesome to see how he conduct the session too. God Bless Him!

Vishal Goel

Leave a Comment Cancel reply