• how to use Offset in a table
    Data analysis

    How to use Offset in a table

    Need to find a value in a large table and you know only the label of the row and column where the target is located? No problem, Excel can help you do it with only two formulas: Offset and Match.…

  • Excel formula
    Data analysis

    Excel countif formula

    Whenever you need to count the elements inside data series the excel countif formula is available to help you reach your target easy and fast. The Countif formula has the following structure: =COUNTIF(Range,Condition) Note that the Range can be a…