i need this sorting with functions and whenever i upload a new value so it has to take automatically sort
i need this sorting with functions and whenever i upload a new value so it has to take automatically sort
You could use LARGE & SMALL Formulas to sort your data.
Uploading an attachment will assist Forum Members in finding the correct Solution for you. Create a dummy worksheet if necessary, add your start data and show where / what your expected results should be. TO ADD A FILE:
Go to 'Advanced. click on 'Manage Attachments. Select 'Browse & Choose your file, Select 'Upload and then close the Attachment window.
in place of dates if it is names with age
name32
name25
name17
name10
You should enter your data in 2 columns, one for the name and one for the age.
If you need to extract the age from your data into a seperate column use: =RIGHT(A1,LEN(A1)-MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))+1)
if the data will be like this
Abcd12
Date20
Abcd2
Date200
Numeric5
Numeric2
Helper column to determine sort order:
=COUNTIF($A$2:$A$7,"<="&A2)
change < to > for Z to A sorting. To return a sorted list:
=INDEX($A$2:$A$7,MATCH(ROWS($1:1),$B$2:$B$7,0))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
thanq for your concern and quick reply
but Mr.Glenn sorting as per age not as per characters or words
Last edited by beepetark; 12-30-2019 at 01:13 PM.
Upload a sheet showing REPRESENTATIVE raw data AND manually calculated expected results.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks