Hi,
In the attached file I have created a lookup table in columns A to C that extract in alphabetical order into column A the product names from column M for which the data is flagged as “non-lagged”. In columns B and C the relative performance of these products is calculated.
I would like then to sort the data in the lookup table in descending order of the values in column C. However, this doesn’t seem to work properly as the values in C seem to be regarded as text even though they’re formulae.
Could someone please have a look at this and also suggest if it’s possible to add a filter button to column C so that the table can be sorted with one click.
Thanks!
Bookmarks