Welcome to Excel Jet Consult blog post. In this tutorial, we will learn about Absolute Cell Reference. An Absolute Cell Reference is a cell reference that contains dollar signs ($) before column letter and row number (i.e. $A$1). The dollar signs ensure that cell $A$1 is fixed when formula is copied down or across using the fill handle. To apply […]

Welcome to Excel Jet Consult blog post. In this short video tutorial, we will to learn how to use the VLOOKUP function approximate match. Enjoy

Welcome to Excel Jet Consult blog post. In this short video tutorial, we will learn how to dynamically apply conditional formatting to our  data with List Data Validation drop-down. Enjoy the video

Welcome to Excel Jet Consult. In this video tutorial, we will learn how to sum contiguous and non_contiguous values using VLOOKUP & SUM functions with array formula. Enjoy the video