how can i make exce sort a column of data so that A+ is listed before A and A- after A and so on?l?
474688
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!
1153191
I find that irritating as well.  I would suggest one of two things:\n\n1) \nHighlight cells in question\nGo to FORMAT pull down menu and select CELLS\nSelect the NUMBERS tab\nIn the CATEGORY window, select NUMBER and indicate how many decimal places to the right (or select whichever number category you deem appropriate)\nClick OK\n\n2) Worse Case Scenario\nType a single apostrophe in front of the number in each cell\nDon't worry, the apostrophe will not be visible after you hit the Enter/Return key\n\nGood luck!
72978
I'd use the vlookup function.\nInsert another column between the 2 you have, then (thinking that you'll have column headers) in b2 =vlookup(a2,C:C,1,false) this will bring back the value if you have it in the second set (which should now be in col C). Paste it to the bottom of your data set.\nCopy the formula into col D, & paste down.\nI'd then sort by col B then by D. What's matched is good, what isn't is unique to the column.\nHope this helps
839840
To make the PIN number show up as a wildcard string:\n\nSelect the desired cells (Column A) right click and select "Format Cells", Select the "Number" tab, and go to "Custom".\n\nIn the cell that now says "General" type:\n"****";;;@\nexactly as shown\n\nAs for the other part, I think your best idea is to use an additional column and use the LOOKUP function.  Don't forget that you can always hide the extra columns by right clicking and selecting "Hide"\n\nHope this helps!\n\nPS  If none of this works, or if you have additional questions, email me at ThuckingSplut@yahoo.com, RE: Yahoo Answers - Excel.  I'll do my best to help you out!
942085
u can do alt + 3 = ♥\nor <3\n\nxox <3 <3 ♥♥♥♥ <3 <3
36375
Here are a few. Obviously, mark every cell with its possibilities. Once new information is found eliminate that # from both the row, column, and section - often times people forget the section. 1) Look for singulars by row and column. Check if there is only one cell that contains the possibility of #, and therefore by default must be that #. This generally reveals nothing early on but may be necessary when you're gridlocked. 2) Look for pairs. For example, if you had 3 cells left in a row and they had the possibilities {237, 37, 37, 2468, 12} you immediately know that the first cell must be 2. Huh? Yeah, because the pair of 37's requires that they be either a 3 or a 7 and therefore you know that the cell that can only be a 237 must be the 2. This works within a section and within rows and columns. This can work with triples but if you have triples of triples you generally have too much unknown. 3) Look within the section and rows. This is hard to explain but let's say that you need a 5 in two out of the three cells in each section of a row. Let's say that the first section you know needs a 5 in one of those two cells, then by default you can eliminate the 5's in all of the other cells in that row because you know that the 5 must be in the first section. Not a very good explanation and it might be redundant, but I already typed it so I won't delete it. Good luck.
153486
No , it will change the order of variales.\nThat is you will get the vlue of xp insteat of xq. If you change p-th column q-th column.
267445
In the address column, type in one address, put a comma, then type another address, etc etc.
705798
Use data validation.  \nSelect the column, choose Data / Validation...., \nchoose "Allow" = "Text length",\n "Data" = "Less than or Equal To", and "Maximum" = 30\nIf you want fo find out how many characters you have in cell:\n=Len(Cell)    i.e., =Len(B1)
434435
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
348716
Can't do that in Excel. The best thing you can do is type your headings in row 1 in each column.
537104
Nine (9) - before 10 and after 11\nOne (1) - before 2 and after 0\nOne (1) - before 2 and after 0
1068967
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.
923037
Beware using CSV- If your data has any commas in it, it will give strange results - mixed up input data. Try saving your data in a newer format or strip out any commas
346407
I think it is order(N squared), so not very good. It's a variant of bubble sort, which you can google. Plus you never know when you're done!
760528
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
428028
An extended example:\n\nSELECT * FROM MYTABLE ORDER BY date,price