sorting numbers in a given order in excel -


in excel want sort columns in given order. example, given have list of columns of id , beat b, want sort columns id in order given oder , corresponding value of beat matches sorted order of id.

given following list of id , beat

33345666 3  44563334 7     39304955 0  22352564 3  76488854 4  23456784 0

what want sort columns of occurrence in order of id in following order

44563334     33345666     23456784     22352564     39304955     76488854

so like:

44563334 7  33345666 3  23456784 0  22352564 3  39304955 0  76488854 4

what easiest , convenient way this?

as example, if list giving order want put items in sheet2 a1:a6 add column 

=match(a1,sheet2!$a$1:$a$6,0)

then sort on that. aware ids aren't in list return #n/a error. can around wrapping in iferror function, eg 

=iferror(match(a1,sheet2!$a$1:$a$6,0),99999)

Comments

Post a Comment

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

i have following sample code used pre-decrement void function(int c) { if(c == 0) { return; } else { cout << "dp" << c << endl; function(--c); cout << c << endl; return; } } this function give output input 4 : dp3 dp2 dp1 dp0 0 1 2 3 but when use post decrement void function(int c) { if(c == 0) { return; } else { cout << "dp" << c << endl; function(c--); cout << c << endl; return; } } output goes in infinite loop dp4 can explain me in detail why happens ? this happens because function(c--) called same value of c , when finishes c decremented. recursively called, hence called same value no chance of return , hit stack overflow error. assume this, int x = 1, y = 0; y = x++ result y == 1 , x == 2. if y = ++x , bot x , y 2.
Read more

c# - Retrieve google contact -

i'm using .net retrieve contact info google contact. however, retrieves including sent email not stored in contact. there anyway can retrieve contact contact? here code requestsettings rs = new requestsettings("", email, password); rs.autopaging = true; contactsrequest cr = new contactsrequest(rs); feed<contact> contacts = cr.getcontacts(); foreach (contact contact in contacts.entries) { name name = contact.name; response.write(name.givenname + " " + name.familyname + "<br/>"); foreach (email emailid in contact.emails) { response.write(emailid.address + "<br/>"); } response.write("<br/>"); } im using google.gdata.contacts package nuget v 2.2.0 string redirecturi = "urn:ietf:wg:oauth:2.0:oob"; // build base oauth2 parameters var oauth2
Read more

javascript - How to insert selected radio button value into table cell -

i have 5 radio buttons <input type="radio" id="rating">1 <input type="radio" id="rating2">2 <input type="radio" id="rating3">3 <input type="radio" id="rating4">4 <input type="radio" id="rating5">5 i have 1 table <table id="mytabledata" border="1" style="width:100%"> <tr id="templaterow"> <th>ratings</th> </tr> </table> one add button <input type="button" id="add" value="add" onclick="addradiovalue()"> i've written code dynamically add rows table, when select radio button , click on add button, value of selected radio button should inserted new cell within table ratings. i able thing text box, i'm not able radio button. can me? your problems didn't have name set on radios , tryi
Read more