Search results for query: *

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

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...

Thank you You two, you have been a great help

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...

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

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...

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...