If I have values in cell A2=2,4,8,6,12,19,18,23,35,78,101,38,30,205,2 And I want to sort by smallest to largest or largest to smallest in cell B2. then my desired result should be =2,2,4,6,8,12,19,18,23,30,35,38,78,101,101,205 or,Large to small= 205,101,101,78,38,35,30,23,18,19,12,8,6,4,2,2 if I have textvaluse like in A3= WPN/01,AFF/02,PROP/4,ENG/03 Then I want to sort alphabetically my desired result should be in cell B3=AFF/02,ENG/03,PROP/4,WPN/1
78683
I'm looking for a decent sort implementation for arrays in VBA. A Quicksort would be preferred. Or any other  other than bubble or merge would suffice.  Please note that this is to work with MS Project 2003, so should avoid any of the Excel native functions and anything .net related.
88965
To concatenate a certain four cells, I'd use:  =CONCATENATE(A2,",",C2",",D2,",",F2)   This would make it so that...   A2 = "Matthew" C2 = "Mark" D2 = "Luke" F2 = "John"   would result in Matthew,Mark,Luke,John.  But we run into problems with something like...   A2 = "Jesus" C2 = "" D2 = "Mary" F2 = "Joseph"   which would result in Jesus,,Mary,Joseph.  Here, the extra comma is undesired. Is there a way to gracefully handle this so that all non-blank cells are included in the comma-separated list, while avoiding the addition of unnecessary commas when some cells are blank?  Certainly, this can be done with a fair number of nested IFs, but I really want to avoid that if possible. Can it be done with native Excel functions, or perhaps an array formula? Or would one have to resort to VB Script for something like this?
12569
I have a table "number" having a column "n" which is of type int. I inserted some values like,  n -- 1 3 5   8   10  Now I want to the column n as 1,2,3,4,5. That is 3 should be changed as 2, 5 as 3, 8 as 4 and 10 as 5. The values of column n should be reordered with the missing values. How can I do it?
629
I have a column of cells where each cell contains one of the following text values  Optimal Normal High-Normal Mild Moderate  Severe   I would like the cell colour to be a set depending on what the value in the cell is.  For Optimal I'd like a green and for Severe I'd like a red, and for the others I'd like a different colour in between.  How do I do that?
60487
I have this input:  sdkxyosl 1 safkls 2 asdf--asdfasxy_asd 5 dkd8k  jasd 29 sdi44sw 43 asasd afsdfs 10 rklyasd 4   I need this output:  sdi44sw 43 dkd8k  jasd 29 asasd afsdfs 10 asdf--asdfasxy_asd 5 rklyasd 4 safkls 2 sdkxyosl 1   So i need to sort the lines by the last column.  I don't know how many columns are in one line.  I just can't figure it out, how to do it. I don't have "perl powers". I just have ~average scripting powers with sed, awk, cut, etc..   Does somebody know how to do it?
65552
I am no expert with excel so any help is appreciated!   I am trying to make one cell do multiple searches within another.  I know that to search one cell for a specific word you would use  =FIND(Blue,C2)   But I need to find multiple different words in one cell. Heres an example of what im trying to do:    I need to show all the allergens in the ingredients cell eg peanuts, gluten, milk, sesame seeds etc   How do I get the result to list all the allergens?   I know that I can do a single find function in separate cells and then concatenate them, but there must be a more simple way?  Thanks
116734
Suppose I have a text string like "11+5" or even "=11+5" stored in a cell. Is there a function in Excel that will allow me to actually evaluate that string as if it were a formula?  This would be helpful for another project where I would like to be able to write 'dynamic' formulas in Excel.
24577
For example, I want the first entry in Column B (B1) to show A5, then B2 shows A10, then B3 shows A15.  How would I go about doing this?
1038
In column A I have a set of numbers (over 1,000), and I want to get an average of a block of them at a time, (e.g., 10, so A1:A10 then A11:A20 and so on) and write these averages into column B, such that B1 contains the average of the first block, B2 the second block and so on.  Then, in C1 I would like to have a value which defines the number of rows each average should consider (e.g., 10 = A1:A10,A11:A20... and 25 = A1:A25,A26:A50... and so on).  When I change the value of C1 I want column B to update automatically to average using the new block sizes.  How should I go about doing this?
100185
I was looking at   and I wondered if the following could be done from terminal. I did it in python, just want to see if it could be done from terminal, bash scripting or whatever.  Suppose I have a file that looks like so:  2,4,5,14,9 40,3,5,10,1   could it be sorted like so, by rows (lines)  2,4,5,9,14 1,3,5,10,40   or is it too complicated? I did it using python, I just want to know if it could be done so next time I might not use python. What I have done, is creating lists and sorting them.
34938
I have lists of files that contain a few columns of data. It is not sorted the way I want from the output, so I'm manually hunting for where a line should be. Is there a way in Notepad++ to sort the lines alphabetically? If so, how?
96703
How can I copy values in cell twice in another column? The values are in column A and I want them have copied in column B, like this:     A B 0 0 1 0 2 1 3 1   2   2   3   3   etc etc etc  EDIT: I saw it looks different when the question is posted, therefore I added a photo.
3484
I have data that looks like this:  Id | Loc1 | Loc2 | Loc3 | Loc4 ---+------+------+------+----- 1  | NY   | CA   | TX   | IL 2  | WA   | OR   | NH   | RI   And I want to convert it to this:  Id | LocNum | Loc ---+--------+---- 1  |   1    | NY 1  |   2    | CA 1  |   3    | TX 1  |   4    | IL 2  |   1    | WA 2  |   2    | OR 2  |   3    | NH 2  |   4    | RI   What's the easiest way to do this in Excel 2007?
121870
I'm using a Query in Google Sheets to pull data from another sheet. That query looks something like this:  =QUERY('Raw Data'!A2:AB,"SELECT E, A, C, D, Y, R, S WHERE S = 'New York'",1 )   What I'd like to do, though, is build a custom sort order within the function so that the Query automatically sorts by rows that have "string1" in column E, followed by those that have "string2" in column E, etc etc. The desired order is not alphabetical so I can't use a clause to sort in ascending or descending order.  I'd also prefer to do this without having to create another sheet where I rank my sort order in a table.
96092
I have three columns as shown below. What is the best way to pull all the values from column 3 that are not the same in the other columns? the result should return 2, 7 and 9 as they are only in column 3.   Column 1 |  Column 2  | Column 3 ---------|------------|--------- 1        |    5       |     1 3        |    4       |     2 1        |    5       |     7 4        |    6       |     9   I tried  not in (Column 1, Column 2) method but it checks by row only and I need it to take first value in column 3 and compare against the whole column in 1 and 2....
83488
I'm running into this weird problem with Google spreadsheets: if the cells have comments on them and I sort the spreadsheet, the rows sort but the comments stay in the same position, and don't move with the cells they're attached to.  In other words, the cells look like this:  A C  &lt;-- comment on this cell B   and then I sort by this column:  A B  &lt;-- comment remains on this cell (stays in position) C  &lt;-- comment should have remained attached to this cell   This means that sorting is completely broken and I can't use it at all, because I clearly need the cell comments to stay with the cell they're attached to.  Is this a bad bug in Google Spreadsheets, or am I missing something here?
13246
I have the task of creating a simple Excel sheet that takes an unspecified number of rows in Column A like this:  1234 123461 123151 11321   And make them into a comma-separated list in another cell that the user can easily copy and paste into another program like so:  1234,123461,123151,11321   What is the easiest way to do this?