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

  • 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

  • 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?

  • count function seeing formulas in cells as data

    How can you overcome the count function seeing formulas in cells as data? This makes the count and associated functions useless for any pratical purpose.

  • 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