Search results for query: *

I have table organized as below: Plant Product Jan-05 Feb-05 Mar-05 ..... GA a 10 12 3 GA b 19 5 63 SC a 20 38 25 How do I get the data normalized? I know how to do for one variable, but not two?

I am trying to import a Notes View into Excel using Microsoft Query. The Query work, but the numeric and date field come in a text. I need to be able to use in calculation. Since someone else will be using the data, I am hoping to get the data corrected coming in. The is a file that will be...

I am a major newbie...so please be gentle. I have the following select statements. SELECT Download_Schedule.Machine, Download_Schedule.EndDateTime, Download_Schedule.ordnumber, Download_Schedule.customer, Download_Schedule.Qty, Download_Schedule.brand, Download_Schedule.BagSpecNo...

How can automatically format an entry into a Word table to the currency format? Example: Enter 6957.11 Desired Display Result $6,957.11

I have a worksheet with several columns of data, sorted by column A. Is there a way to insert a page break automatically whenever the value changes in column A?

I am new to using Project Central. How do I enable my resources to change the start, finish or duration time for a task?

I want to calculate the newworkingdays between two dates. If the answer is 1, then format the ## day otherwise format the cell ## days. I am using Excel 2002. Any help is appreciated.

Can anyone help me with a formula to calculate elasped work time? The time is for a group working a five day schedule Monday to Friday, Hours 8:00 AM To 5:00 PM. The data is currently arranged with the start date in one cell and start time in a second cell, but they can be combined. The...

I have 2 column list. Column A has employee ranking. Column B has employee names. I need to pull the names of the employees with "Excellent" Ranking to another worksheet. Can anyone help me with the formula to use? I don't want to use a VB.

I am trying to print to a HP 8150N. I would like to take a document that is currently printing portrait 2 pages and print it landscape on one page (page 1 & 2 side by side. Any help would be greatly appreciated.

How do I create a chart that represents one data point at the intersection a an x and y value Example Name Sales DPC SJA 1000 200 JWE 2500 400 KOP 1500 300 I want to graph the intersection sales and DPC with the name beside the data point.

How do I define a field as numeric when using Query to import a field? Currently the field comes in as text. I can't change the data source, which is a Lotus Notes Database.

I need to automatically populate blank cells based on the first non blank cell above. Any ideas? Not all cells are blank in a row. Variable # of blanks rows.

Numeric data is coming in as text from from a lotus notes view. How do I define the data as numeric?

I have a worksheet file with 68 sheets. Can anyone suggest an automated way to write each worksheet to a separate file named the same as the worksheet.

I have established an ODBC link to a Lotus Notes view. However when the data comes in the numeric values are text. How can I fix so that it will always import correctly as numeric?

I am trying to use query to access an external database, however some of the data is coming down as text when it should be numbers. Is there a way to define the specific fields as numeric?

I would like to calculate the average of a variable length group of numbers eliminating the maximum and mininum values.

How can I count the unique record in a worksheets? I have serveral different field that I want to count.

How can I email a worksheet from a Excel Visual Basic macro? I am running VB 6.0, Excel 2000, and Lotus Notes 5.0.4.