If a cell (e.g. A1) contains a list of integer values (e.g. "10,28,38,9,14") and I want to extract the highest value from that list into another cell (in this example it would be 38), how can I do it?
136555
parse the data into multiple cells and use the large function. ie: =LARGE(A1:C1,1) will return the largest value in the cells a1 through c1
568984
Microsoft Excel only keeps a numeric value with upto 15-digits of percision, which means any number greater than 15 digits is converted to scientific notation, and the 15 most significant digits are retained.\n\nYou can, however, display a larger number by displaying the number as a "text" value, by placing a single quote before the number.  This text number will not be able to be used within calculations.
629595
Assume you have only A1 to A10 contain a number of 1,2,3 and B1 to B10 contain the # of days\nput this anywhere, say B11\n=SUM(IF(A1:A10=1,IF(B1:B10>2,1,0)),0) \nyou will get #VALUE!\nthen keep your cursor stay at B11, hit F2 then Ctrl+Shift+Enter to make it an array formula, the above formula in B11 should be in brackets { }.\nTo clarify a few points in above formula...\nin the formula the A1:A10=1 is your criterion - only 1 not 2, not 3\nthe B1:B10>2 is also your criterion - over 2\nthe last 1 in the formula is if the 2 criteria on each row are met, add 1
401036
There are built-in functions in a programming language to perform that task.For instance in C++ we have: cint("string value") for converting the string value into integer.And in Visual Basic we have the val() function to do the same thing.
41040
You could do something like:\n\n\nDim captionString As String\nDim numEntries As Integer\nDim ctr As Integer\nnumEntries = 0\n\nFor ctr = 1 to Len(txt.text)\n    If (Mid(txt.Text, ctr, 1) = "a") Then\n        If (numEntries > 0) Then\n            captionString = captionString & ","\n        End If\n        captionString = captionString & ctr\n        numEntries = numEntries + 1\n    End If\nNext ctr\nLabel1.Caption = captionString\n\nThe idea is that everything inside the For...Next loop is done at each position of the string, and so you build up the string to put in the caption of Label1.
479320
I think you're on the right track, but you need to move some things around.  Try this\n\ndouble highestgrade = Double.MIN_VALUE;\nString highestStudent = "";\nwhile ((oneLine = fileIn.readLine()) != null) \n{\nStringTokenizer st = new StringTokenizer(oneLine, delim);\nString student = st.nextToken();\ndouble grade = Double.parseDouble (st.nextToken());\n\nif(grade > highestGrade)\n{\nhighestGrade = grade;\nhighestStudent = student;\n}\n}\nSystem.out.print("Highest Grade: " + grade + " Student: " + student);
270716
Best is to format the cell by right clicking on it....and choosing format cells....under Number tab choose Custom...and type format as 000 (no. of zeros upto the digits u require)....and enter..\n\nBy doing so ull be storing numbers as numbers and with leading zeros....\n\nI dont agree with typing '048 as it stores numbers as text\n\n\nhope this clarifies ur doubt
36236
Unfortunately, no. You'll need to parse the integer from the String entered in the text field. You can use JTextArea or JTextPane or even JPasswordField. To compare the values you'd either want to use a JButton at the bottom (for the user to click once he/she is finished entering text) and then parse an integer out of it.  View the sources below (especially the API) to view the different subclasses of the different types of text components in Swing. If you need help parsing the integer out of it, then let me know and I'll tell you how to do that (if I'm on, so don't count on it ;). Good luck!
465268
This function I've wrote takes the right cell as argument, and, if  that cell is not empty, returns it's value , otherwise the value of the cell above the cell where the function resides: \n\nFunction MyFunction(rightcell As Range)\n   Application.Volatile True\n   MyFunction = IIf (rightcell (1, 1).Value <> "", rightcell (1, 1).Value, rightcell(1, 1).Offset(-1, -1).Value)\nEnd Function\n\nTo make the function available proceed as following:\n-Press Alt+F11- this will bring up the VBA editor\n-navigate to Insert > Module to open a blank module screen\n-paste the above code there\n-close the VBA editor\n\nAs in your example,in  B3 cell, you will call te function like this:\n =MyFunction(C3)
193714
In excel all the cells are numbered - A1, A2, A3 as you go down the page or A1, B1, C1 etc as you go across the page.\n\nIf you have a list of numbers in cells A1 to A10 for example then to add them together you would enter =(sum A1:A10) in a different cell (lets say A11).  The result that was displayed in A11 would be the sum of the numbers in cells A1 to A10.  Note that only numbers can be added so if one of your cells contained an unrecognized format (e.g. a date or text) then it wouldn't be included in the calculations.\n\nYou can add up blocks of cells simply by changing the range.  If you look at your Excel spreadsheet and imagine date in each of the first 4 rows of the first 4 columns then the formula to total up these 16 cells would be =(sum a1:d4).\n\nYou can also use the method described above by clicking the cells you want included in the total - particulalrly useful if the values to be added are scattered across different rows and columns.\n\n------------------------------------\n\nAs regards inserting a page number you need to click on File > Page Set Up > Header / Footer and then either Custom Header or Custom Footer depending if you want the page number at the top of bottom of the page.\n\nDecide whether you want the page number on the left, center or right of the page by positioning your mouse pointer in the corresponding box and then click on the second of the 2 icons - it has a symbol like this on it... #\n\nYou can add text before and after the page number so that your sheets could, for example, read 'Page 1 of 7' 'Page 2 of 7' etc.
450206
You don't even have to move to each cell.  Try this.\nIts unclear what you mean by grab the data but I'll put the values into an array.\n\nsub FindOpenCell()\ndim VarArray(10000)\nrowcounter = 1\ndo until cells(rowcounter,1) = "" \nVarArray(rowcounter) = cells(rowcounter,1)\nrowcounter = rowcounter + 1\nloop\ncells(rowcounter, 1).activate\n\nEnd Sub
436276
If the information in schools.xls is in more than one column (if the info includes the school name in one column, # of students in another, etc...) choose one value that doesn't have repeats.  School name would be a good choice.\n\nIsolate that information in one column, copy and paste if needed.\n\nIn the column directly to the right of your schools info, in the top cell, enter the follwing:\n\n=rand()\n\nThat will put a rand number between zero and one in that cell.  Double click on the box at the bottom right of the higlight to copy the formula down all of your data.  Then, choose the data menu, and sort...\n\nsort by the columnwith your rand om numbers, either ascending or descending.  Then take the first 30, 50, or 70.  In order to preserve randomness, after each set, hit f9 to refresh the random numbers and sort again.\n\nHope that's clear.\n\nTo be fair, the answer below this one is a bit simpler.  At the bottom of the tools menu, select Data Analysis.  Scroll down until you see sampling. Drag a box over the schools info, select random, and put n in for the number of samples.\n\nCan't win 'em all.  :)
381772
Use the following - this will work:\n\nIf IsError(Range("A1")) Then\n... Code\nEnd If
199403
Put this in C1:\n\n=(12-A1)-(12-B1)\n\nHave the cell formated to time.
176289
Highlight B5 in the formula and press F4.\n\nThis will turin it into an absolute formula $B$5 and will remain fixed.\n\nThe other thing you can do is give the cell reference a name (e.g.B5VALUE) and this can be encorporated in formulaes on any worksheet.  This is an example of a named cell reference.\n\nSee source for more details.\n\nHope this helps
328039
The last formula works because you are evaluating the range with an array formula "countblank"\n\nin the original formula you are trying to evaluate a range of values in the condition section of your "if" formula wich is not an "array" fild. This can be done if you conver the formula to an array formula.... Simply hold shift+ctrl when you enter the formula....\n\nthe formula will appears like this\n\n={ IF ( OR ( $C$49:C64=0 ), " ", C64-C63 ) }
610497
The A to Z button answers are correct, but you typically do not need to select your range to sort. Excel will expand to all the contiguous columns and rows. \n\nThen only time you need to select your range to sort is if either an entire or row or column is empty in the middle of your range.\n\nObviously if you are sorting only one column in the middle of other data and do not want the other columns to sort along with it you need to just select the data in that column. The sort button will ask you if you want to expand the selection.