i download info from a financial website. i then sort the data for my own use. one of the columns used in my sort has + and -   in the data, ie. A+ or A or A- or C, C-. when i sort it arranges A first, then A-, then A+, then B, B-, etc. i wish to get A+, A, A-, B+, B, B- as my sorted order on that column of data. is this possible? how is it easily done?
215443
Custom lists are your answer.\n\nFirstly, create a column with the rankings, in descending order, A+ down to C-.  Then select the list, and go to Tools / Options, and then the Custom Lists tab.  The cells selected should be in the Import box on the bottom right; click Import to add them to a custom List.\n\nNow you can sort by this custom list.  Select your main dataset (i.e. the list of downloaded data), and go to sort as per normal, by your ranking column.  However, before sorting in Descending Order, click the Options... button.  From the dropdown menu in here, you can select all the custome lists available - and hence get it to sort by your A+ to C- ranking.\n\nHope that helps!
627370
I would never use a column name with a parenthesis in it, so I think you should change that first.\n\nJust call the column name instead....like select 1 from table etc...if its in column 1.
570423
My coldfusion is pretty rusty (php guy now) but the first question that comes to mind is, rather than use 2 seperate queries, why not use one?\n\nTry SELECT * .... etc\n\nWHERE order_ID = (SELECT MAX(order_ID) FROM Orders)\nORDER BY ... etc.\n\nThis is called a subquery or correlated subquery.  Most SQL databases support the idea.
159317
It completely depends on where you are using this formula, is it in Excel? A program? What language?\n\nWe need more info.
12516
Yes. Each column should have a condition and mutiple values can be given in IN operator.\n\nFor ex The above one can be written like this\n\nSELECT *\nFROM TABLE_NAME\nWHERE COLUMN1 IN (col1val1,col1val2)\nAND COLUMN2 IN (col2val1,col2val2)\nAND  COLUMN3 IN (col3val1,col3val2,col3val3)
208238
to do something like that in word you would have to convert the text into a table (found under the table menu) then sort the table (sort is also found in the table menu)
373341
You put tallies in the table.(Small lines in set of five).eg If digit 3 comes 8 times in a distribution, you put four tallies and cross them with fifth tally diagonally and than after a space add three more tallies,because its easy to count set of five in large data.if 8 comes 4 times than you put four tallies.(////)
387162
1) Left click on first cell in row.\n2) Hold down the shift key and Left click the cell AFTER the last grade\n3) Sum button
605107
It seems that you may have a sum function built into this thing--you know how many times the code GHI occurs, for example.  Maybe you manually counted them, but I suspect they are tabulated for you in some way.\n\nSo build a table.  The first column would list any possible code for a given day.  The second column would list any possible code for the following day.  The third column lists how many times that occurs.\n\nFor example, suppose that the only possibilities are A, B, and C.  I might have the following table:\nA A 5\nA B 3\nA C 4\nB A 7\nB C 2\nC A 1\nNotice that this means that an "A" day has been followed by an "A" day 5 times, by a "B" day 3 times, etc.  A "B" day has never been followed by a "B" day.\n\nOnce this table is created, simply sort it, using Column 1 as the first sort key, column 3 as the second sort key (putting the most likely successor at the top of the list), and column 2 as the third sort key.
544599
Easy, type $A$10+B8. The $ before A will anchor the column whereas the one before 10 will anchor the row.
44302
Ya if you ever need to find a percent of something multi. by 100 or just move the decemial 2 spaces to the right. That does the same thing as Multi. by 100.
92484
Place the cursor in the first column of the row column descriptions, nagivate to DATA>FILTER->Auto Filter (select).  Now move to the column with say Pet type and Select "Kitten".  Move to the column with Stock balances and select Custom->Less than or equal To and enter 100. I hope this helps and answers the question.
510816
First you would have to create an extra column to have the range in it:\n\nName IQ Range\n---------------------\nJohn 110 100-130 \nRick 120 100-130 \nMary 140 130-160 \nJean 170 160-220 \nToby 210 160-220 \n\nTo put the data in that new columns you can use UPDATE statements like this:\n\nUPDATE Table SET Range = '100-130' WHERE IQ >= 100 AND IQ < 130\n\nThen you can do a select statement with a group by to get the results you want:\n\nSELECT  Range, Count(*) FROM Table\nGROUP BY Range
194458
It may be easier to use an array list.\n\n  Dim al As New ArrayList()\n\n   al.Add("This")\n   al.Add("Is")\n   al.Add("My")\n   al.Add("New")\n   al.Add("ArrayList")\n   al.Add("Control")\n\n   Console.WriteLine("Before Sort:")\n   WriteElements(al)\n\n   al.Sort()\n\n   Console.WriteLine("After Sort:")\n   WriteElements(al)\n End Sub\n\n Private Sub WriteElements(ByVal al As ArrayList)\n   Dim i As Integer\n   \n   For i = 0 To al.Count - 1\n     Console.WriteLine(CStr(al.Item(i)))\n   Next
285056
order of operations is important but it's impossible to know what exactly do you mean when you write words instead of math symbols, so I would guess that you mean this\n1+1/1-1*1/1=\n\n1+1-1=\n\n1+0=\n\n1
597709
You could add a temporary number column and use autofill to fill it down to the row which contains the last of your name data.\n\nSelect both this column and your name column and sort the name column alphabetically (ascending). Delete the blank rows (which should now be at the top) and then re-sort (ascending) by your temporary number column.\n\nThen delete the temporary number column.
459534
This formula will put a minus sign in a second column's entry when the first column's entry is a minus or the positive value if positive.\nA1=first entry\nA2=second entry\nPut into A2:\n=IF(A1>0,A1,"-")