Search results for query: *

I have this excel file that needs to be formatted for some old fortran program. In excel, it looks something like this: Site Atim Zo VS ----- ----- ----- ------ Main St. 60.00 0.00 0.00 1st St. 20.00 0.00 0.00 Washington 80.00 10.00 10.00 The...

Hi, I'm pretty new to VBA and I've got this problem with some data I'd like to format. The data is formatted like this: Date Time Value 2/10/04 22:00 25 2/10/04 23:00 26 2/11/04 00:00 27 2/11/04 1:00 28 2/11/04 2:00 29 .... 2/15/04 1:00 30 2/15/04 2:00 31 The data continues for several more...

Hi, I'm writing a report with a number of figures. I've inserted captions for each figure but the numbering seems to be screwed up. The numbers jump in multiples of 3. For example, I have a Figure 2, then it goes to Figure 5, then Figure 8, etc. The field codes for the captions are all the...

Hi, I have query that join two tables together. Table 1 Site Element A-1 Iron A-1 Copper A-1 Zinc B-2 Iron B-2 Lead Table 2 Element Percent Iron 60% Copper 20% Joins into Query 3 Query 3 Site Element Percent A-1 Iron 60% A-1 Copper...

Hi, I have an excel question regarding sorting individual columns. I have data in such a format Iron Lead Zinc 0.5 0.3 0.2 0.1 0.2 0.1 0.2 And I would like it to be in this format Iron Lead Zinc...

Hi, I have a question about querying environmental data so that it is transposed (sort of). I have an Access table with three fields, Element/Chemical, Date, and Result. For example, I have: Element Date Result ------- -------- --------- Iron 2/1/03 10...

I may have asked this question before but I can't seem to find the past post. I have some water quality data to compare against government standards. Out of a dataset, I need to get a percentage of how many datapoints exceed the standard. Right now, I'm doing this with the Excel function...

I put together an external harddrive using a Coolmax enclosure and a Maxtor 120GB drive. It was working fine before, but now the transfer rate has gone down significantly and sometimes freezes or stops in the middle of transferring large files. I'm just wondering if anyone has run across a...

Hi, I asked a question a few weeks/days ago about removing single quotes. I've tried the advice given to me but with no success. I've imported a spreadsheet from Access to Excel. In the Excel spreadsheet, there are single quotes at the beginning of every cell. At the time, the single...

Hi, I have a project that requires me to compare bunch of water chemistry data with certain limits. I might have 10s or 100s of data points for a certain chemical and I need to get a percentage of data points that exceed the limits. For example, I might have five data points for mercury that...

Hi, I have a spreadsheet that I've imported from Access to Excel97. In the excel spreadsheet, I keep getting these single quotes in every cell. I've tried running a replace to delete these single quotes, but it doesn't work. Does anyone know of a way to get rid of these single quotes...

Does anyone know if it's possible to do super/sub script in an excel cell? If so, how do you do it? Thanks in advance for your help.