Translate

Tuesday, March 21, 2017

Key Advanced Skill: Creating List from scattered entries by Avoiding/Ignoring/Skipping empty rows



Objective
You are working on a data set and want to get your results based upon certain criteria.  Now the problem is your result contains blank rows / rows which do not qualify with your criteria. You want result as a list i.e. without blank rows. 

This model/method resolve many data picking/filtration issues,therefore in my opinion its a KEY concept.

Tuesday, March 14, 2017

VLOOKUP Search in middle or right column & get result from left side column(s)



Objective
VLOOKUP always search in left column and get result from right side. How to make VLOOKUP search in right column and get result from left column.