Pages

Search

Excel Help Forum - Excel General: Conditional Format for Peak Flow Meter -COPD

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
Conditional Format for Peak Flow Meter -COPD
I need to conditional format Air Flow grid according to the color scale shown. Posting the reading places the number correctly but the color format is lost. These meters are used for people suffering from COPD and a spreadsheet would be most helpful. Thanks for your help.

Excel Help Forum - Excel General: How to add 1 to a calculated cell if a range of cells are not empty?

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
How to add 1 to a calculated cell if a range of cells are not empty?
This is difficult to describe. I am trying to calculate "Projected yearly gross". The gross is divided by the number of accumulated weeks. So, if we are only 10 weeks into the fiscal year then the gross amount is divided by 10. Currently, I am altering the cell by changing the number each week by...

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...
Subscribe to: Posts (Atom)