Currency count for salary disbursement with special requirement

When the cash salary is to be disbursed to many employees, the currency of different denominations are required to make the payment. Some times currency notes of few denominations may not be available. Before making the payment the payer should be ready with the cash of required denominations. The¬†Currency count… Read more »

VLOOKUP Function in excel

VLOOKUP is the popular and widely used formula in MS Excel. VLOOKUP function searches given value ( lookup_value) in the left most column of the table and returns the value in the  given column (col_index_num) of the matching row. The syntax for VLOOKUP is: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) Lookup_value: lookup_value … Read more »