Home
Knowledge Base
Corporate Interventions
Contact Me

Category: DATA EXTRACTION

Extract tab name in cell

{ 21 Comments }

By Ashish Mathur · August 18, 2006 · DATA EXTRACTION · Leave a comment

You may refer to my formula in this workbook to extract the tab name in a certain cell

LinkedIn
Facebook
Twitter
Email

Linkedin0 Facebook0 Email0 Twitter0

LOOKUP where search string appears multiple times

{ 244 Comments }

By Ashish Mathur · February 6, 2006 · DATA EXTRACTION, POWER QUERY · Leave a comment

In a list with multiple occurrences, the VLOOKUP() function in Excel will only return the first occurrence of the string being searched. 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 If you are using the […]

LinkedIn
Facebook
Twitter
Email

Linkedin0 Facebook0 Email0 Twitter0

« Previous
1
…
4
5
6

Search for:

Recommendations from LinkedIn

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

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

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

WordPress + rtPanel

Send to Email Address Your Name Your Email Address

Cancel

Post was not sent - check your email addresses!

Email check failed, please try again

Sorry, your blog cannot share posts by email.