| Thread | Last Post | Replies |
|
| How to correct a mis-spelled word not in Dictionary? | 31 Jan 2008 11:20 GMT | 5 |
Please assist me in correcting a mis-spelled word which is not found in Dictionary, directly from the spell-check pop-up box. I appreciate anyone of you who can offer me your help. Thank you.
|
| sorting dates in a worksheet | 31 Jan 2008 10:04 GMT | 3 |
I have a worksheet where the first column contains invoice dates I have entered dates as follows in the first column 25-01-08 05-05-07
|
| Removing Columns | 31 Jan 2008 10:03 GMT | 3 |
Working with Excel 2003. I have a spreadsheet with a large numbe of empty rows. Have tried to delete them but more appear. I have also tried the hide command with no success. Seeking guidance on how to display just the columns that have data. Advice sought
|
| Birthday probability | 31 Jan 2008 09:43 GMT | 8 |
I can work out the probabilities for 2 people in the same room sharing a birthday by dragging formula down like so No People Different Same % 2 364 365 99.73% 0.274%
|
| CREATING PDF FILES FROM EXCEL FILES | 31 Jan 2008 06:39 GMT | 2 |
I tried to create pdf file from aexcel file by right clicking on the excel file. On right clicking, it shows a context menu in which I click on "Convert to Adobe PDF". Finally I get the pdf file but on opening the file, I find all the contents are masked by Black band.
|
| Excel FTP - Full Time planning | 31 Jan 2008 06:37 GMT | 1 |
Do we have any template for Full Time Planning (FTP) in EXcel? The sheet needs to be automated based on inputs from another sheet. If so please share
|
| How to merge two chart types in Excel 2007 | 31 Jan 2008 04:58 GMT | 2 |
I have created a column chart and now I want to plot an x-y scatter chart on top of it, but I do not know how to have both of those plot styles in one chart.
|
| excel 2007 miscalculation | 31 Jan 2008 04:43 GMT | 3 |
try this: A1 = 154.2 B1 = 1700 C1 = A1*B1 give answer 262140 (correct)
|
| Getting rid of text in a data set and replacing it with an average of the numbers either side of it. | 31 Jan 2008 04:41 GMT | 2 |
Table is here http://www.federalreserve.gov/releases/h15/data/Business_day/H15_FF_O.txt I have taken this table and graphed it. Problem is on public holidays there is an ND - For Example
|
| Conditional Formatting (Formula) | 31 Jan 2008 03:09 GMT | 6 |
Hi, What I'm looking for is for cell C10 to change color IF the 9 cells above it are blank. Any ideas? The cells above it would either be blank or "x".
|
| Manipulate a Range | 31 Jan 2008 02:57 GMT | 1 |
I have a formula that looks for the min value in a range say Min(A2:A5) and a marco that runs each minute expands the range by one row. So after one minute the new range is A2:A6, then one min later A2:A7, etc. What I really need is for the min function to look at a range of one ...
|
| Auto fill/list | 31 Jan 2008 02:45 GMT | 1 |
Ok i want to auto fill a range of numbers in a column, ok lets say in a:1 is 0 and a:557 is 556, how would i be able to auto fill these empty cells a:1-a:557, after this i would need to do the same for b:1 of 0 through b:557 of 20.
|
| SUMIF + Conditional Formatting | 31 Jan 2008 02:37 GMT | 2 |
I was hoping for some help with a formula. I have a list and I have applied conditional formatting that when the cell has a value of 'Yes' the whole row is colored red. I am trying to calculate totals but I don't want to include any of the
|
| Count the cell contain a specific numbers in a range | 31 Jan 2008 01:52 GMT | 5 |
wud like to figure out the value which is start with 10 digit which present by True or False. See this:- TRUE 4420940138 中山有限公司
|
| Formating Excel Spreed Sheet | 31 Jan 2008 01:43 GMT | 1 |
I am creating a spreed sheet and I am using only columns A through G. I was wondering how do you cut off all the other rcolumns (so you don't scroll and only see columns A-G)?
|