Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
search massive
Hi, i have a real large file for excel, about 200.000 - 400.000 rows ... i am using new office 12 pre-release for this ... also using assistance of previous versions (because some codes do not work in office 12) and i need to see how many info that i like to display in my document ... my info is like ... 70 72 70 74 71 75 ... and 200.000 - 400.000 like this one ... HERE, i need to find about 500 info like above in my document ... like again ... 70 74 73 71 70 72 so forth ... simply, i could not search one by one how many 500 info in my document ... i need a solution that search all 500 info which i'll enter like above, in one action .. and also i like to DISPLAY how many in numbers of each ... i do not know is it possible ... for people who like to know, i need it for visual-audio programs and creativity ... thanks and regards ... -- lynch44 ------------------------------------------------------------------------ lynch44's Profile: http://www.excelforum.com/member.php...o&userid=33867 View this thread: http://www.excelforum.com/showthread...hreadid=546097 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i build a search table in excel | Excel Worksheet Functions | |||
build a search tool in excel | Excel Discussion (Misc queries) | |||
Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) | |||
Wildcard search functions within Vlookup | Excel Worksheet Functions | |||
FAQ Spreadsheet with search function | Excel Discussion (Misc queries) |