Hi,
I have 2 columns, A and B. A contains names, B contains values which I'm using to rank the names in the column A. I get the values in column B from another part of the sheet. I can easily rank the names in column A from the largest to the smallest value in colomn B. But when I change the data source ,and by doing so changing the values in column B, I have to manually re-rank the names. Is there anyway I can set it to automatically rank column A if the values in column B are changed?
Thank you in advance.
/Karl
Bookmarks