| Thread | Last Post | Replies |
|
| Datedif formula | 18 Apr 2008 20:50 GMT | 3 |
I am trying to figure out the number of months between a start date and the current month. I am using the formula =DATEDIF(MONTH(TODAY()),G4,"m") but it is giving me the wrong answer. Ex. the start date is Sep-07 and it is returning 1291 as an answer and the column is formatted as ...
|
| Conditional formatting to color rowsbased on cell value | 18 Apr 2008 20:49 GMT | 1 |
How can I color rows based on the cell value of one cell in each row? That is, if I use conditional formatting to test the value of cells in column P, I can color cells in that column with conditional formatting, but I want all cells in each row to have the format of the cell in ...
|
| External Data | 18 Apr 2008 20:19 GMT | 1 |
I had tried to import data from an access database. It didn't work so I delete the table and continued other tests. I finally have thing setup the way I need them but now when I iopen the spreadsheet it keeps giving me an error about the initial data source.
|
| Font Size Changes in Pivot Table Upon Refresh | 18 Apr 2008 20:13 GMT | 1 |
This is a really annoying problem that shouldn't be this hard. I have a pivot table in which I want the font size to be 12. However, when I refresh the table or do anything to it the font size changes back to ten. Not all the cells change, which makes the report look strange
|
| choose+match!! | 18 Apr 2008 19:32 GMT | 1 |
given : range A range B range C range 44 1 b xa range 45 2 b xb
|
| Enhanced lottery question | 18 Apr 2008 19:21 GMT | 5 |
The rules of the game are this Pick 6 numbers and you must keep this six numbers until someone wins. assume you pick 1, 2, 3, 4, 7, 8 Assume that the lottery numbers in week 1 are
|
| Getting the correct SUM answer | 18 Apr 2008 19:05 GMT | 1 |
Good morning, I am having a lot of trouble with the formulas in a spreadsheet and can't quite figure out how to word what it is that I need. Hopefully this will at least come close enough to get a little help. =/
|
| Multi Part Lookup | 18 Apr 2008 18:56 GMT | 3 |
Store # Jan Feb Mar 1 471,374 488,292 3 - - 4 488,295 470,050
|
| Email with excel | 18 Apr 2008 18:29 GMT | 1 |
Here is the code that i have so far. The range A1:A2 is where emails are stored. The range will become larger when this works correctly. I am trying to email multiple recipients based on information that I have in cells on a worksheet. Any guidance woudl be greatly
|
| Color and Date | 18 Apr 2008 17:53 GMT | 1 |
I have date column and i need Friday in red color and rest of the week days in blue color How can I do that?
|
| COUNT and SUM with multiple criteria | 18 Apr 2008 17:50 GMT | 2 |
Two seperate functions I'm having problems creating. First, I need a COUNT of the number of cells meeting TWO sets of criteria. For example, "column A=final" AND "column B=14". Seperately, I also need a sum of values in "column C" for the same
|
| Checkbox to Unhide Rows | 18 Apr 2008 17:43 GMT | 3 |
Is it possible to use a check box to 'Unhide Rows'? What I would like to do is have a client select a check box(es), then press a button I have inserted into the spreadsheet to run a macros. This macros would Unhide rows according to which boxes have been checked. Or is there ...
|
| HOw can I copy a protect cell to paste somewhere other than excel? | 18 Apr 2008 17:40 GMT | 1 |
I am trying to copy a sheet from excel into powerpoint. I want to protect certain fields and leave other open. I know I need to lock and protect them before I copy/paste, but I can't select the protected locked cells. Any ideas. Thanks,
|
| HELP! HOW TO COMBINE CHARTS IN MS.EXCEL | 18 Apr 2008 17:39 GMT | 1 |
Hi. Im a business student but im taking computing class as it is compulsary. i have an assignment to combine 2 charts. i have 2 data sets ( sales 2007 and sales 2008). The sales 2007 is in sheet 1, while sales 2008 in sheet 2. i have to make 1 chart showing a comparison
|
| Digital Signature | 18 Apr 2008 17:07 GMT | 1 |
How do you digitaly sign a document so you can veiw the signature after you print the document.
|