Pages

Search

Excel Help Forum - Excel General: Repeating the calculations every x column

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Repeating the calculations every x column
I want to repeat the calculations using the data in every xth column. See below. Know how to do that when going down the column but at a lost when trying to do it across the column. How can I tell it to use the data in column 1, then column 1+x, then column 1+x+x, etc ? Many thanks. ...

Excel Help Forum - Excel Charting & Pivots: VBA Code to Produce Multiple Pie Charts (data in columns)

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
VBA Code to Produce Multiple Pie Charts (data in columns)
Hi Please could I get some help creating multiple pie charts from a series of data. I have a sheet with the data columns as so: Code: --------- Name Complete Incomplete

Excel Help Forum - Excel General: what correlation coefficent to use.

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
what correlation coefficent to use.
what correlation coefficent to use. I have right clicked on the trendline and format trendline and show the R-squared equation. I have also used the 2 columns (costs and profit) and used a RSQ formulae I have also used the Pearson's r formulae. The question I have is what does each of...

Excel Help Forum - Excel Charting & Pivots: Add 2nd data set to chart with new X values

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Add 2nd data set to chart with new X values
Work have just upgraded me to Office 2010. I want to add data to a chart that has different x-values to the set it was created with. Used to be I'd make a chart then go to add data, highlight the new columns, in the pop-up window tell excel that the first column is new x-values and the top row...

Excel Help Forum - Excel General: Saving Text Data

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Saving Text Data
How can I save data from a worksheet as a CSV file ensuring that my text data saves as Text and not as General? I need to save a CSV file where I have columns with numbers with leading zeros (Formatted as Text. Example: 0000000232). However, when I save the file, the data in these columns are...

Excel Help Forum - Excel General: [SOLVED] Required the total of odd number of each doc.no and mention count n...

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
[SOLVED] Required the total of odd number of each doc.no and mention count no.from excel working
I have a file with so many datas.But here for requirement is total of all odd number of each document and mention the count no.against each doc.no.Is it possible through Excel working? For more clarification,please refer the attach file.

Excel Help Forum - Excel Charting & Pivots: Time lines with flexible time intervals...

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Time lines with flexible time intervals...
I have a small series of data that includes: dates, irreguar times, and two columns of temperature data over the range 20 deg C to 40 deg C. The dates are sequential, but the irregular times reflect observation times that may be taken once, twice or three times per day but at no particularly...
Subscribe to: Posts (Atom)