Tags: COLUMNS

Dynamically extract unique values with multiple conditions

{ 8 Comments }

By Ashish Mathur · February 15, 2009 · DATA EXTRACTION, DUPLICATES AND UNIQUES, POWER QUERY · Leave a comment

Assume there are two columns with data repeated in all both columns. One may wan to extract the unique text values from a specific column based on conditions specified by end-user. Depending upon the version of MS Excel which you are using, there could be two ways to solve this problem Solution for MS Excel 2010 and higher versions […]

LinkedIn
Facebook
Twitter
Email

Linkedin0 Facebook0 Email0 Twitter0

Search for:

Recommendations from LinkedIn

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

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

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

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