In excel sheet, is there a way I could check for column data that has the same name or description?
462802
In the menus, go to edit, find, then type in all or part of what you're looking for.
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.
687364
In spread sheet 1 I created the following\nSorry but the formatting is not to good.\nColumn A\n1\n2\n3\n\nColumn B\nhello\nhi\nhowdie\n\nIn spreadsheet 2 I created this\nColumn A\n1\n2\n3\n\nColumn B\n=LOOKUP(A1,Sheet1!A1:B3)\n=LOOKUP(A2,Sheet1!A1:B3)\n=LOOKUP(A3,Sheet1!A1:B3)
105195
I assume both Worksheets are in the same file...\n\nIf so, you simply do the following:\nIn the second worksheet in the cell you want to display something from the first worksheet, type:\n\n=SheetName!CellName\n\ni.e. if your info is on a Worksheet called Sheet1 and the cell is B1\n\n=Sheet1!B1
1172805
I would use Data Validation and VLOOKUP in Excel to do this.\n\nType in the 2 lists (for convenience lets start in A1) then add a third column:\nSerial#1          Combo#1          =A1\nSerial#2          Combo#2          =A2\nSerial#3          Combo#3          =A3\n\nMake the lists as long as you need. We created the third column for later; it just copies the serial numbers over to simplify things for the VLOOKUP formula.\n\nNow that the data is input we will need to create a drop-down menu. Since the data is in columns A-C, click in E1 to select the cell and click Data | Validation… In the Allow box choose List and type the range for the combinations in the Source: field (in our example: A1:A3). Now, click on F1 and type this formula:\n=VLOOKUP(E1,A1:B3,2,FALSE)\nIn the parentheses you will have this data: \n-E1 is the criteria you will look up in the array.\n-A1:B3 is the array where the data resides (remember this is from the example, yours will be longer).\n-2 in our formula tells VLOOKUP to pull the data in the 2nd column that matches our criteria from the 1st column.\n-False tells VLOOKUP to look for an exact match.\n\nWe have now created the Serial Number lookup that returns the proper Combination. To lookup the Serial Number from the Combination, we just do the steps again.\n\nClick in E2, choose Data | Validation… Again, in the Allow field choose List, but this time we need the combinations in the drop-down (B1:B3); click OK. The formula for F2 is almost the same:\n=VLOOKUP(E2,B1:C3,2,FALSE)\nThe only differences is that the criteria and array are shifted; the criteria down one row and the array over one column.\n\nIf you wish to hide the rows that contain the array, just right-click on the column headings and choose hide.
310492
A simple two column lookup table with one column with values to match and another column with values to return. Two columns A & B:\n\n7 Bike\n8 Car\n9 Boat\n\nOn another sheet or workbook you could use the vlookup function to find in col A, a number and return the value in the second column.\n\nTo find car the formula would be =vlookup(8,A1:B3,2,False)
128367
There is actually a good one as a sample spreadsheet template in Microsoft Excel. there is even a better one in the older versions of Microsoft Works spreadsheet tool.
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.  :)
672487
Yes, VLookup is what you need\nPaste this function in B column in sheet Y\n=vlookup($A1; X!$A:$D; column(); false)\nwithout these spaces..and fill down and right\n\nXLMan
112029
The microsoft downloads page has several for excel
588082
If your data is spread across many sheets, but the layout of the sheets is the same (i.e. the columns and formatting are all identical), and you want to get all the data on to one sheet, then just copy and paste it together on to one sheet.\n\nWithout knowing more details, there is no quick way to avoid just doing it by hand.
610232
Make one on a spreadsheet
233468
I've uploaded a simple spreadsheet to the link below.  Anything else and you should probably find someone in the office who knows Excel.
505781
Sub ChooseLastRow()\n\nRange("A1").Activate\nDo until activecell.value = ""\nActivecell.offset(1, 0).activate\nLoop\nactivecell.offset(-1, 0).EntireRow.select\n\nEnd Sub\n\n\nDo what ivpjennings suggested. MUCH more elegant. Completely forgot about that!\n\nBe careful with the xlLastCell. There's a bug in Excel. If you are working with your data and you delete a few rows, the xlLastCell will still be the last row of the original data set, not the updated last row after the deletions. Only after saving the file, will xlLastCell return the true correct last row.
391107
USe the function "CountIF"\n\ne-mail me for more details
718467
go to the Format column, and then go to Cells...\nIn that box, pick TEXT. it will display your number exactly how it is written.
567687
u can use the SELECT command\n\nSELECT fname, lastname FROM biodata\n\nbiodata is the table name and fname and lastname are the fields u want 2 be displayed