Here is the Sample Excel sheet\n-------------------------------------\nE-212-ACBN\n5-ADS-3432\n5-DSD-2343\nE-232-ASDD\n-------------------------------------
126708
You haven't indicated which version of ASP you want to use nor what you want to do with the data once it's read.\n\nAssuming you want to read the info into a GridView in ASP.NET 2.0:\n\nhttp://support.microsoft.com/?kbid=311731
28717
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
276192
Here you go:\n\nhttp://www.usd.edu/trio/tut/excel/index.html
417199
http://www.officerecovery.com/excel/\n\nTry here if the help in Excel doesn't help.\n\nRegards\n\nRob
257563
There are a lot of software libraries that do that:\n\nhttp://tinyurl.com/k9zah\n\nincluding some for Excel:\n\nhttp://tinyurl.com/hrda7
270720
You don't need VLookup here you need another function, which is countif..\n\nif your column in C, put this function in D4\n=COUNTIF(C:C;"*banana*")\n\nand enjoy\n\nremeber, if you like it, I want my 10 points...\n\nI am the XLMan
213932
aren't u missing a number there on the last row???\n\nin that case... i would say...\n\n9 11 13 15 17 19....
410633
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.
621543
http://www.hardtofind800numbers.com/listings/a.htm
531057
it is from a logic work sheet.  directions are find the next item in the pattern.  examples:  12321, 23432, 34543, 45654\na, z, b, y, c, x, d\ntam, tan, rib, rid, rat, raw, hip
438058
SrSe\nK2O\nCa3N2\nCoI3\n\nthe numbers should be subscripts
174213
Provided you use MS Office, try this - http://office.microsoft.com/en-us/templates/CT061993551033.aspx\n\nGood luck !
438409
I accept the challenge for the fun of it.\n\n...will get back to you.\n\n\nOK.  in cell G5, based on what you describe, the formula is "=VLOOKUP(+E5,$B$2:$C$5,2)"  Note the dollar signs in the formula referring to cells B2 and C5.  This will allow you to copy cell G5 into G6, G7, G8, and so on if you have more values in column E.\n\n\nNOTE: In column B2 to B5 are the numbers 0, 32, 63, and 94 respectively.  In column C2 to C5 are the words Freshman, Sophomore, Junior, and Senior respectively.
9997
I'd copy the emails from each sheet & do a vlookup to each set. Delete the ones that are matched & then do a vlookup to the original sheets to bring ini the rest of the details.\nI'd take them into Access tho if you can. You could link the sheets to a data base & export the query results back to Excel.
539943
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
559184
27824\n\nHyde County\n\n252 Area Code
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