I have the following data, in cells A2 to A10 I have names and in cells B2 to B10 I have numbers.in cell A1 I have column header called name and B2 have column header called rank.
Is it possible that everytime the rank column changes, it will sort out ascending accordingly?
Again,thanks for the help.
Is it possible that everytime the rank column changes, it will sort out ascending accordingly?
Again,thanks for the help.