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…

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…

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…

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…