Tag: MATCH

Lesson#106: How to lookup picture in excel

Okay friends here I will show you an interesting tricks about Excel. That is how to lookup picture in excel. We have  learned looking up values from a table but looking up picture from table is little different. Here in

Tagged with: , , ,

Lesson#69: Get the Kth largest or Kth Smallest

When you want to get the smallest or the largest number from a array then it’s just using the function MAX and MIN. But if you want to get the Kth largest or Kth smallest then there are more two

Tagged with: , , ,

Lesson#49: Make a parent gantt chart from a data table

Here I have to make a parent gantt chart from a data table. It is a gantt chart summary as per BOQ (Bill of Quantities) Item and RA Bill No. wise. This bar chart will be followed with chainage value

Tagged with: , , , , ,

Lesson#41: Combination of INDEX and MATCH function is better than any other lookup function

INDEX function returns a value or reference of the cell at the intersection of a particular row and column, in a given range. Syntax of this function is INDEX(array, row_num, [column_num]) where array is required, If array contains only one row or one column

Tagged with: ,
Top