In excel how can find the largest value in a column?
965931
u can do it by sorting, filtering i know , other participants already gave u that so i'm including this one\n\nfor largest value \n=MAX(B1:B3)\n\nnote the reference value of this cell in the left top \n\nfor corresponding day \n=LOOKUP(cell reference value of max,B1:B3,A1:A3)\n\ni think it's the best answer
404712
You can do this by VLOOKUP\n\nSheet 1 contains the full list \nSheet 2 your item codes\n\nIn Sheet 2.\nB2=VLOOKUP(A2,Sheet1!A1:C3,2)\n\nThis looks up the value in A2 in the range A1:C3, and returns the second column (B).
709713
You can simply use an "IF" statement.\n \nLet's say in A column some cells have values & some don't - for the one that has a value (non-blank), you'd like put the number "2" next to it (in the B column), here the formula -\n\n=IF(A1<>="",2,"")\nThis means if A1 is not blank, then put 2 in B1, otherwise leave it blank.
391107
USe the function "CountIF"\n\ne-mail me for more details
921289
If you are only trimming the 0 from the front ( which is what I get from your description ) just use the RIGHT function. Add a column to the right of your data and use this formula.\n\n=RIGHT(A1,LEN(A1)-1)\n\nYou will need to change the A1 to match the reference of your first cell; then just copy the formula alongside your data.\n\nTo eliminate the formulas once the 0s are gone, just select the data in the new column, Copy, then Paste Special... over your original data. Now you can delete the new column.
645072
Select the range of cells you want to sort. Select Data-Sort.  Select the Column you want to sort by. (next sort col etc) then select Ascending Descending and click OK.  If you have selected a header row select that option to make sure it does not get sorted and mixed with data.  Good luck.
653602
Do you have Excel, if you do, then Excel can do that.  I think the formulas are self explanatory but if it isn't obvious to you, a Google search should turn up on how to do this in Excel.
1181970
The exact works, but can be cumbersome.\n\nThe best method is vlookup.  It is designed for exactly what you want to do.  However, there are 2 things  you need to do first.\n\n1) get rid of unwanted spaces before or after the last name.  To do this, use this formula in column C =trim(b1).  This trims the spaces off and puts the remainder in column c.  Repeat for the data in column F and put the result in Column G\n\nNow copy the data in C and Paste Special if back into B.  Repeat, moving data from G to F.  Delete the data in columns C & G.\n\n2) You have to sort the data in column B (your lookup column).\n\nNow you have all that done, the vlookup.\n\nin your now empty column F, do this:\n\n=VLOOKUP(G1,$b$1:$b999,1,FALSE)\n\nWhat this does is lookup what is in G1 and searches the range b1 through b999 (change this as needed), it will return the data in the first column (you can get back another column's data if you wish - you have to use multiple columns after the first ,) and it looks for an exact match (this is the "FALSE")\n\nRepeat for each row.
826611
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.  :)
419698
In a blank column use the function =LOWER(whatever cell) and the text will appear in all lower case. Then copy the lower case column on top of the original column and do a Paste Special and paste "values" and your original column will now be lower case. There are also functions for =UPPER() all upper case and =PROPER() which returns first letter capitalized and the rest lower case.
186438
Check http://www-class.unl.edu/psycrs/handcomp/hc1t.PDF\n\n\nAlso, Follow this procedure:\nEnter the values of X into the designated cells, beginning in the top-most cell. After each entry, depressing the 'tab' key will take you down to the next cell in the column. After completion and verification of data entry, click the button labeled «Calculate». If you wish to perform another analysis with a different set of data: click the «Reset» button if the value of N for the new set of data is undefined or smaller; click the «Reload» button if the value of N is larger than undefined.\n\nImporting data from a spreadsheet. Within the spreadsheet application, select and copy the column of data. Then return to this page, click the cursor into the data-entry field and perform the 'Paste' operation. It is important to make sure that the final line in the data-entry field entry is not followed by a carriage return. (An extra carriage return at the end of the list will be interpreted as an extra data entry whose value is zero. Importing data via the copy and paste procedure will almost always produce an extra carriage return at the end of a column.) After the bivariate list has been pasted into the data-entry field, click the cursor immediately to the right of the final entry in the list, then press the down-arrow key. If an extra line is present, the cursor will move downward. Extra lines can be removed by pressing the down arrow key until the cursor no longer moves, and then pressing the 'Backspace' key (on a Mac platform, 'delete') until the cursor stands immediately to the right of the final entry.\n(see http://faculty.vassar.edu/lowry/t_single.html)
532438
You can use the =MAX and =LARGE functions to identify the five highest scores without resorting each time.  (This will add five rows to your spreadsheet (one for the highest, another for the second highest, etc.) but you can then hide these rows if they are cluttering up the spreadsheet.)  Then total these amounts and divide by 5.
792191
If you really want them to be numbers, then change the format of the cells. Use the number format "0000#" (or however many zeros you want).\n\nHowever, VLookup will not match the leading zeros in this case because the internal format of the numbers will be mathematical not textual. If you want to store the numbers as text (for instance, if they are ID numbers) then preface them with ' when you enter them. This tells Excel not to evaluate the cell.
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
1056758
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.
482701
"mode"\n"display digits"\n"float 12" (or however many you want - 12 is the highest)
501771
=COUNTIF(A3:A6,"CO")  A is column \n\n=COUNTIF(B3:B6,">55") B is column