Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need codes to extract some data
File 1 is a daily output of stock information and is large:
CODE DATE OPEN HIGH LOW CLOSE VOLUME ANI 20071003 5.87 5.87 5.87 5.87 5740000 AIOD 20071003 6.26 6.26 6.26 6.26 428700 AIO 20071003 6.68 6.68 6.68 6.68 2953000 ---- ----------- ---- ---- ---- ---- ---- ECU 20071003 0.024 0.025 0.024 0.024 212200 EDEO 20071003 0.245 0.26 0.245 0.26 39667 EDS 20071003 0.62 0.62 0.62 0.62 14500 ---- ----------- ---- ---- ---- ---- ---- IOD 20071003 2.48 2.52 2.35 2.45 472000 IOF 20071003 1.8 1.82 1.795 1.815 7093641 IOH 20071003 0.72 0.72 0.665 0.7 129936 ---- ----------- ---- ---- ---- ---- ---- ZRL 20071003 0.49 0.49 0.48 0.48 61667 ZYL 20071003 0.051 0.054 0.05 0.052 753700 File 2 consists of my list of selected stock codes, where the CLOSE and VOLUME data is needed to fill the blanks. CODE CLOSE VOLUME BOC FLO IOD ---- SED Is there a way to do that? I much appreciate any help. Regards, Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing Up Data Based on Codes | Excel Worksheet Functions | |||
HOW CAN I CONVERT EXCEL DATA TO BAR CODES? | Excel Discussion (Misc queries) | |||
HOW CAN I CONVERT EXCEL DATA TO BAR CODES? | Excel Discussion (Misc queries) | |||
missing data codes | Excel Discussion (Misc queries) | |||
Converted data to labels. The 0 in zip codes does not print | New Users to Excel |