October 16, 2015
Excel Magic Trick 1169
DESCRIPTION Extract Top 20 Values & Dates: Formula, Array Formula or Power Query? Learn how to extract Top 20 values and dates for those values using Formulas when there are no duplicates, Array Formula for […]
Two Lookup Values For VLOOKUP? How Do I Do That? (6 Methods) DESCRIPTION See three methods for lookup situations where you have two lookup values: (00:10) What to do if you have two look values […]
DESCRIPTION See how to extract items in List 2 that are also in List 1 using a great array formula from Exceli Adam at YouTube that uses the functions IF, INDEX, MATCH and AGGREGATE. MATCH […]
You must be logged in to post a comment.