| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Import
Hi,
I need to analyse some data that is held in an Access database, but I want to do this in Excel. I have the data in an Access Query. My data is about 7500 records and increasing by 200 records per month. The data record consists of three fields Date in mmm-yy format Text String1 Text String2 I want to group my data in Excel by month with the latest month at the top. I then want to have a count of TextString1 and a count of TextString2. As an example: Month Text String1 Text String 2 Sept-07 25 36 Aug -07 62 89 I am lost as to the best way of doing this, and would appreciate some advise please Thanks A |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import External Data is missing some data | Excel Discussion (Misc queries) | |||
| Prevent equation from skipping data when referencing import data? | Excel Discussion (Misc queries) | |||
| import data from txt file , the data prefix with plus "+" | Excel Discussion (Misc queries) | |||
| how to Import data in excel office2003 with data more 65000 rows | Excel Worksheet Functions | |||
| Import Data: on insert, shift data down and not right | Excel Discussion (Misc queries) | |||
Threaded Mode
