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...
The data is stored in a Notes database, I am using Microsoft query to download the data into a spreadsheet. However, the data has to be converted because it all comes in as text rather than numeric.
The SQL statements are generated when I create the query, so I haven't stored the data anywhere.
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...
Hi, I appreciate your help...however I am getting the following when I try to run the macro (2nd option).
Runtime error '1004'
Unable to set the pagebreak property of the range class.
The range I am breaking on is a person name.
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 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.
I want the x axis to be the sale values, the y axis the DPC value. Place one point at the intersection of the values for SJA and label the data point SJA.
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.