thank you azam for ur help..but it is difficult for some people to come up with formulas like this...i mean is there anyway where we can input a table of multiple rows and columns and get the output in ascending order of values without giving formulas and getting the output just by a couple of mouse-clicks...anywhere not only in excel..