Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. NickSleeman

    Excel Formula that mimics AZ auto sort

    Spot on skip the requirement was to have the highest value at the top with the corresponding category. But good work Zathros you help me to solve my problem Thanks again Nick
  2. NickSleeman

    Is there a way?????

    put this formula in a blank column ="b" & A1 where A1 is the cell where the first number is Drag the formula all the way down to the last row of your data by highlighting the cell and dragging down the bottom right hand corner. Cut and paste special values over your original numbers...
  3. NickSleeman

    Excel Formula that mimics AZ auto sort

    Thank you You two, you have been a great help
  4. NickSleeman

    Excel Formula that mimics AZ auto sort

    Thanks again, however, even with the correct range I am getting duplicates in column E if the values in column F are the same. I have been messing around with an offset formula as well as index/match formulas. =OFFSET(LARGE(value,Row()-1),0,-1) for column E, but I am not quite there, as you...
  5. NickSleeman

    Excel Formula that mimics AZ auto sort

    Thanks Skip. However, I am finding that when I have duplicate values (such as apple and pen in the above example) I only get one category shown twice. Is there anyway to overcome this? Thanks again, Nick
  6. NickSleeman

    Excel Formula that mimics AZ auto sort

    Hello, can someone help please. I have some reports to run which include graphs. These graphs need to show the top 5 categories. I have a list of categories and their associated values, but I would like the graph to refresh the top 5 without me having to press the AZ sort button on the table (I...
  7. NickSleeman

    Get contents of cell and find match on another workbook

    Hi, Can anyone help, I am new to this! I normally use the record feature but cant for this one, so if some one can point me in the right direction that would be great I have a workbook which I have a drop list in column K every other row. I need to get the contents of every other cell in this...

Part and Inventory Search

Back
Top