Excel

Select a solution

  • Function/Formula sorts data.

    Hi all, I would like to know if there is any function/formula Excel provides to help in sorting data. For example, I have my data in Sheet1 as follows: A B Customer Product 1 234 16432 2 432 17094 3

  • Locking a formula or function to a cell

    How do I lock a formula or a function to specific cells, so that even after I sort and these cells move to different rows, the formula or function still picks up on those specific cells?

  • how to sort in formula based cells

    i have made a small excel file for cricket as it calculates the NET RUN RATE but the difficulty is that i want the net run rate column to sort according to largest to small with the team names column

  • FORMULA HELP INCLUDING IF FUNCTION

    i have a formula that calculates the number of days within two dates excluding a list of excluded dates and only using network days. within the formula i have 'not returned' or 'not due' depending on

  • Im looking for a Formula to SORT & Match to get Max

    Im looking for Formula to SORT & Match to get Max for cell CP39:44 THESE ARE THE CELLS THAT I WANT TO WORK WITH for a Formula BE39:BE44 , BL39:BL44 , BS39:BS44 , BZ39:BZ44 , CG39:CG44 , CN39:CN44

12345Forward