| Thread | Last Post | Replies |
|
| Excel range selection as if dragging, keyboard not responding | 22 Jul 2007 15:26 GMT | 1 |
I open an Excel file - I click on a cell then nothing - it just selects a range of cells whatever direction I drag the mouse to. Keyboard does not respond, can't exit out unless I do CTRL-ALT-DEL. How do I fix this? Thanks.
|
| Days, Hours and minutes | 22 Jul 2007 14:50 GMT | 3 |
I currently have a lump of data that is reporting back to me a 10 digit number. I have no idea where the number started (When) but I do know that the increments are in seconds.
|
| Database query and parameters | 22 Jul 2007 14:20 GMT | 1 |
It seems to me that the following things are true: 1. You cannot base and Excel query (using "Microsoft Query" at Data | Import External Data | New Database Query) off of a Microsoft Access query, if the Microsoft Access query has parameters.
|
| Sumproduct and dates | 22 Jul 2007 13:54 GMT | 5 |
=SUMPRODUCT(--(SPRING4!N2:N1549<="1/31/07"),(SPRING4!M2:M1549)) Above is my formula that I can't get to work with dates. I want to sum the M2:M1549 based on the date column of N. What am I doing that is wrong? The date column is formated as mm/dd/yy.
|
| How do I make a web query file to download stock data? | 22 Jul 2007 13:10 GMT | 1 |
I just got Excel and would like some help in making a file which would enable me to download some info from the stock market i.e. option prices. I would greatly appreciate any help anybody can give me. Thanks.
|
| Search actual Formula for cell ref? | 22 Jul 2007 11:55 GMT | 3 |
Other than using Find from the Edit menu, is there any way of (using formula) searching another formula for a certain cell reference? Let's say I have a single column (B) of 100 similar formulas. I want to check that none of the formulas contain a reference to column H, so want
|
| Sequential numbers in a formula? | 22 Jul 2007 11:52 GMT | 2 |
I have a few formulas (OFFSET & MATCH) which are the same (with relative references chanfing accordingly) and occupy cells B2:B500. In each formula one of the function arguments refers to a single cell in the adjacent column i.e A1:A500 which contains the numbers 1 to 500 (and ...
|
| Centre Across Selection oddity | 22 Jul 2007 11:28 GMT | 2 |
Sometimes when I use 'centre across selection' to centre horizontally across more than one cell, if the cells in question have an outside border, the right-hand border often disappears when the left-most cell contents are centred across the selection.
|
| Find/Found | 22 Jul 2007 06:26 GMT | 2 |
Can not get Found to respond. Object: Get PersonName in Sheet2, Go to Sheet1, Find PersonName. If Found put PersonName & address into Sheet2 Else put PersonName in Sheet3. Sheet2 has no address. Sheet1 has most, but not all names that are in Sheet2
|
| excel 95 | 22 Jul 2007 02:16 GMT | 7 |
Where can I get Excel 95. I need it load my old old SuperCal spreadsheets. My new ver of Excel can't handle it.... Thanx Hanz
|
| Compare two file/colunms, hide row not does not equal list. | 21 Jul 2007 23:54 GMT | 3 |
Excel 2000 -have two files. File "A" has 1 through 4155 records (rows with three columns) in numerical order. File "B", has a list of almost 200 rows/numbers (one column) from file "A". How can I hide the rows in file "A", not are listed in file "B"?
|
| Merging cells | 21 Jul 2007 23:11 GMT | 8 |
We have many excel spreadsheets that we use to track employees. My company just recently transfered the info from Word to Excel. I am new to the company and fairly new to Excel. We have decided to merge the name cells from two to one (one cell-first name, one cell-last name). ...
|
| Are there any excel template for creating POIs for Garmin units | 21 Jul 2007 22:00 GMT | 1 |
I'm looking for a template in which I can create points of interest for a Garmin 340c.
|
| find first empty cell in column and start transpose next row in that cell | 21 Jul 2007 18:56 GMT | 3 |
I have the following code to transpose one row into column without blanks and zero's. Dim lastcol As Long Dim ws As Worksheet
|
| search and return cell count | 21 Jul 2007 17:51 GMT | 1 |
I have a list of dates. (certain dates are excluded). I need a formula that would perform like a datedif and lookup formula. Using two cell references, I need to be able to count the number of cells (dates) between the reference points in a formula. Sort of like
|