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 or VBA Function to List Unique values from a range of three columns
Hi, Is there a formula or function to list the Unique Values in a range of three columns? Trying to create a List in Column E of the Unique Values (Product-Lot nos.) in Range B3:D50 as shown above.
- 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