sir,
I want to know formula to arrange cells of a raw in accending and descending order. also want to drag formula to apply other raws also. pl advise.
sir,
I want to know formula to arrange cells of a raw in accending and descending order. also want to drag formula to apply other raws also. pl advise.
Ascending
=SMALL($A2:$G2,COLUMNS($A:A))
Descending
=LARGE($A1:$G1,COLUMNS($A:A))
Cell H1 formula , Drag down and across
HTML Code:HTML Code:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks